MySql Data backup script (not original), mysql Data Backup

MySql Data backup script (not original), mysql Data Backup

Create a file xxx. bat with the following content:

@ Echo off
Set hour = % time :~ 0, 2%
If "% time :~ 0% % "=" "set hour = time :~ 1, 1%
Set now = % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8, 2% % hour % Time :~ 3,2% % Time :~ 6, 2%
Echo % now %
Set host = server address
Set port = port number
Set user = MySql user name
Set pass = MySql password
Set dbname = Database Name
Set backupfile = path for saving database files (set by yourself) \ % dbname %-% now %. SQL
XXXX (there cannot be spaces in the folder name in the path, usually under the MySql installation path bin) \ mysqldump-h % host %-P % port %-u % user %-p % pass %-c -- add-drop-table % dbname %> % backupfile %
Echo delete files before 90 days
Forfiles/p "path for saving database files"/m *. SQL/d-90/c "cmd/c del @ file/f"