mysql backup and restore command under Win

Store the backup database under the d: root directory. The backup database name is backup20070713.sql (20070713.sql is the backup date).

Backup database:

mysqldump uroot - p123456 database_name > d:/backup20070713.sql

Restore database:

Delete the original database, establish the database, the backup database import.

mysqladmin-uroot-p123456 drop database_name

mysqladmin-uroot-p123456 create database_name

mysql uroot - p123456 database_name

Note: before importing the backup database, database_name needs to be created if not; And the database name in backup 20070713.sql is 1 like can import.

Note: environment Windows command line