Mysql automatic backup and Restoration Methods

I. Automatic Backup: Save the following code as a *. bat batch processing script, and then add Windows scheduled jobs, such as running at every day:
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 indicates the database name and password. The system automatically backs up the database to the specified directory at the current date and time.

2. Restore the database: mysql-u root-p databasename <d: \ databasename. SQL