How to take scheduled Backup with MySQL in windows ?

Step 1: 
First you need to install MySQL Server with MySQL Administrator.I  hope that it is installed well in your Computer.
Step 2:
Click  on start >> All programs >> MySQL >> right click on MySQL Administrator  and Run as administrator .Here is the screen shot.

 Step 3:
 Next enter password in MySQL Administration login window. It will open new window. Next select Backup  menu from left hand site menu bar and click on New Project button (shown by Red Arrow).Here is the screen shot.

Step 4:
Next select database from Schemata shown by Green Arrow.Next click on  >  button (show by Red Arrow)   for Backup Content.Next give the Project Name , here i given struts2jqueryapp (show by red rectangle).Here is the screen shot.

Step 5:
Next click on Schedule tab and check Schedule this backup project check-box.Next give the Target folder (folder path where your backup will store) and Filename (backup name same as Project Name by default  you can change also). Next select the Execution Time (show by Green and Red Arrow). Next click on Save Project Button (show by Yellow Arrow).Here is the screen shot.

Step 6:
When you click on Save Project button, it will  open new Account Information window give your Windows Account password (Do not use  your DB connection password ).Here is the screen shot.

Step 7:
Next open Windows Task Scheduler (by click on start >> type Task Scheduler in the search box ).Here is the screen shot :

Step 8:
When you open Windows Task Scheduler you can see your new scheduled task(show by Green Arrow) when you click on the Task Scheduler Library folder(shown by Yellow Arrow) on the left side.Here is the screen shot.

All done.Thank you ,please give you feedback.

Share on Google Plus

About JK STACK

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.