Windows Server server-side MySQL database automatic backup

1. Grant all SQL permissions to the root account

Grant all privileges on * * to [e-mail protected] "%" identified by ".";

Flush privileges;

2. Create a bat batch file

@echo offset path=%path%;D: \program Files\mysql\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:\da Ta\cmsis_%cdate%.sqlexit

Where Cmsis is the database to be backed up, files such as Cmsis_20140510_16.sql are generated under F:\data when the batch file is executed

3. Add a Scheduled task

(1) Add a task plan, task plan, System tools, accessories, and programs


(2) Click Next

Click Browse to select the bat file you just created

(3) Set task execution time



Then click Next to enter the administrator password!