MySQL Backup restore command summary under win

Suppose MySQL is installed in C: disk, MySQL database username is root, password is 123456, database name is database_name, in D: the root of the directory to store backup database, Backup database name is Backup20070713.sql (20070713.sql is backup date)

Back up the database:

mysqldump-uroot-p123456 database_name "D:/backup20070713.sql

To recover a database:

Delete the original database, set up a database, and import the backup database.

mysqladmin-uroot-p123456 drop database_name

MYSQLADMIN-UROOT-P123456 Create database_name

mysql-uroot-p123456 database_name

Note: Before you import a backup database, database_name if not, you need to create it, and you can import it as a database name in Backup20070713.sql.

Note: Environment Windows command line