Batch command bat back up MySQL database

Original: Batch command bat back up MySQL database

Working Environment Windows Server 2003, MySQL installation directory D:\MySQL, WinRAR installation directory C:\Program Files\winrar\winrar.exe
The path to the backup data store is a e:\ data backup, so start writing DOS batch commands below. The code is as follows:

Set "ymd=%date:~,4%%date:~5,2%%date:~8,2%"
MD "E:\ data backup \%ymd%"
"D:\MySQL\bin\mysqldump.exe"--opt-q mysql-uroot-p123456789 > E:\ Data Backup \%ymd%\mysql.sql
Rem..... Here you can add more commands, depends on how many databases you have, where-Q is followed by the database name-p followed by the password
echo Winrar Loading ...
"C:\Program files\winrar\winrar.exe" a-ep1-r-o+-m5-df "e:\ data backup \%ymd%.rar" "E:\ Data Backup \%ymd%"
Echo ok!

Save the above command as Backup.bat, double-click Run, and start backing up the data. The first sentence of the
is to create a variable%ymd%, by%date% the system variable to get the date,%date:~,4% represents the date of the previous 4 characters is the year,%%date:~5,2% that the date of the 5th character from the beginning of the 2 characters is the month,%date:~8,2 This is the date number, as in 2009-06-20 the end result of this date is 20090620
The second sentence is to use the value of the variable%ymd% to create an empty folder.
The third sentence starts with MySQL command to backup database MySQL, and stored in E:\ data backup \%ymd% This folder, here can have a lot of similar commands, backup multiple databases. The
finally uses WinRAR to compress the backed up data and store it as a RAR file name established with the value of the%ymd% variable, while deleting the%ymd% directory of the backup.
If you want the system to be automatically scheduled for regular backups, you can perform this command periodically through the system's scheduled tasks