Thursday, 3 May 2012

MYSQL: Daily auto backup of database for windows or Scheduled backup

Quite simple , because you have read the older post for creating backup  (dump) . But, here the process of automatic backup the mysql database in a particular time in your local system. This may not run your remote system.

Steps for create a schedule for back :-

 Step 1- Create a batch file with the command mysqldump and necessary options that mentioned in the old post .

Step 2- Goto Start => All program => Accessories => System Tool => Scheduled Task

Step 3- Then create a new schedule with given batch file and scheduled date & time.

Now ,  wait for the given scheduled  time and see the backup file is created in the destination directory .