Scheduled Backup With MySQL Administrator on Windows

I just updated to Windows 7 with a clean install so I had to reconfigure all my programs as they used to work on my Vista OS. For some reason setting up a scheduled backup using MySQL administrator is so tricky on many levels.

STEP 1:

Download MySQL Admin (free) Just Google the download.

STEP 2:

Set up your connection info within MySQL admin (easy).

STEP 3:

Create a backup project (also easy).

Wait about 5 seconds for the connection to the DB when you click on the lower left box to see all the tables appear, see below:

STEP 4:

Once you have the backup set up the way you like it, select the save button.

STEP 5:

TRICKY part! Do not use the password from yourDB connection, use it from your Windows account, I verified this works on Windows 7 as well (works on Vista too). You need to have a password assigned to your Windows account for this to work.

Notice that it doesn’t matter if you use the path or not, they both work.

Step 6:

You do not need to set anything up in the Windows Task Scheduler at all! Do not create a task here, MySQL will do this for you. I have wasted much time on this step.

Once you have clicked OK above and then you open Windows Task Scheduler you can now see your new scheduled task appear when you click on the Task Scheduler Library folder on the left side.

As you add more schedules you can just right click and hit refresh the library folder to see the new ones appear.