Automatic MySQL database backup on Windows Server

1. Grant all SQL permissions to the root account

Grant all privileges on *. * to root @ "%" identified ".";

Flush privileges;

2. Create a bat batch file

@ Echo offset path = % path %; D: \ Program Files \ MySQL Server 5.5 \ binset y = % date :~ 0, 4% set m = % date :~ 5, 2% set d = % date :~ 8, 2% set h = % time :~ 0, 2% set cdate = % y % m % d % _ % h % mysqldump-h 127.0.0.1-u root -- password = *****-e-R -- database cmsis> f: \ data \ cmsis _ % cdate %. sqlexit

Cmsis is the database to be backed up. When the batch processing file is executed, a file such as cmsis_20140510_16. SQL is generated under f: \ data.

3. Add a scheduled task

(1) Program-> accessories-> System Tools-> Task Plan-> Add Task Plan


(2) Click Next

Click Browse to select the created bat file

(3) set the task execution time



Click Next and enter the administrator password!