How can I run the mysql backup and recovery command in Win? assume that mysql is installed on a c: disk, the mysql database username is root, the password is 123456, the database name is database_name, and in d: the backup database is stored under the root directory. the backup database name is backup20070713. SQL (20070713. SQL indicates the backup date)
Back up the database:
Mysqldump-uroot-p123456 database_name> d:/backup20070713. 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
Note: Before importing a backup database, if database_name does not exist, you need to create it. it must be the same as the database name in backup20070713. SQL to import the database.
Note: Windows command line