Mysql automatic backup and restore method _mysql

Automatic Backup: Save the following code as a *.bat batch script, and then add Windows timed jobs, such as 2 o'clock in the morning daily:
Set s=%date:~0,4%%date:~5,2%%date:~8,2%%time:~1,1%%time:~3,2%%time:~6,2%
Mysqldump-u root-ppassword databasename > D:\databasename_%s%_bak.sql

Note: DatabaseName for the database name password the database password, the system automatically backs up to the specified directory at the current date time.

Second, restore the database: mysql-u root-p databasename <d:\databasename.sql