Huh? Take too long?
Now I'm really curious about your idea of long and short timespans.

As you must obviously already know the username and password to your MySQL Server, those two blanks are the easiest to fill in.
Then you need to find out the path to where you installed the MySQL Server.
That should be pretty easy to find: It's eiter C:\Program Files\MySQL\MySQL Server x.x or C:\Program Files (x86)\MySQL\MySQL Server x.x or you changed the path to something custom, in which case you should definitely know where it is.

That's all that needs to be filled out.
Shouldn't take more than 2 minutes to figure those 3 out.

Now you need to create a batch file:
Create a new text file in Notepad and make sure to select the All (*.*) type in the dropdown when saving, so the filename is really something.bat and not something.bat.txt

Last step:
Run a command as admin. Search for CMD, right-click the dosbox icon, select run as administrator, type in the path to your just created bat file and hit enter.

Everything done thereafter.
Shouldn't take more than 10 minutes at most.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode

To Moderators - I now know why you received "3" of the same posts from me, It is NOT my fault.
Using the Chrome browser - created post using 'quick reply' - Hit submit once I was done. Nothing happened. I hit submit once again and it took the same post into the editor. My post was still not visible so I changed font color (Why not, it was there.) and submitted the 3rd time.

This time however I was able to see two (2) and was able to edit this one. Hence my attempt to notify you of what happened. I did not see a 'delete' option. Once this has been read - please delete it for me and please look into why this occurred. I take great pride in being not only courteous but also accurate in anything I post to a forum. (ANY forum)

Shannon Marissa

_________________
Shannon Marissa

Hahaha, oh sorry, I completely misunderstood that. And as much as I'd like to blame it on poor understanding of the english language (which still happens from time to time, especially when people want to be sarcastic or have slight undertones), I must admit that it was just me reading only half of the words in your post.


You can just add another checkbox in the task scheduler to run a task with admin privileges. Just add the "/RL HIGHEST" option to the command for creating the task:

You might want to delete the old task first. Either by looking it up in the task scheduler by hand or by running

As for PowerShell CmdLets: Once you enabled running PowerShell scripts at all, there's nothing keeping you from just typing the same stuff found in a batch file. You only get addon functionality and barely loose anything that was there in CMD batch files.
Self-elevating PowerShell scripts will only work in interactive context as they require confirmation from the user. You can't use that for running a powershell script in user mode from the task scheduler and then have it magically get admin privileges. That would completely undermine the privelege separation of Windows.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode