MySQL backup and recovery COMMANDS IN WINDOWS

Assume that MySQL is installed on the C: disk, the MySQL database username is root, the password is 123456, the database name is database_name, And the backup database is stored under the D: disk root directory, the name of the backup database is mysqldb20100615. SQL (20070713. SQL indicates the backup date)
Back up the database:
Mysqldump-uroot-p123456 database_name> D:/mysqldb20100615. SQL

 

Restore database:

Delete the original database, create a database, and import the backup database.

Mysqladmin-uroot-p123456 drop database_name
Mysqladmin-uroot-p123456 create database_name
Mysql-uroot-p123456 database_name <D:/mysqldb20100615. SQL

 

Note: before importing a backup database, if database_name does not exist, it must be created. It must be the same as the database name in mysqldb20100615. SQL to import data.

Note: Windows Command Line