Simple mysql backup and Restoration

Note: Do not operate in mysql, but directly in cmd.

 

Backup: Back up a database named taskone to a specified file at a specified location.
Mysqldump-h 127.0.0.1-uroot-proot taskone> D:/taskone
 
Restore:
Step 1: Create a database with the corresponding name in mysql
Step 2:
Mysql-h 127.0.0.1-uroot-proot taskone <D:/taskone
 
 
Note:
1. During restoration, you must first establish a database and then restore the data in it.
2. The backed-up files are stored according to their own names. If you want to view the files, you can back up them as follows:
Taskone. SQL
If the file name is taskone during backup, you can change it to taskone. SQL.

 

Excerpted from: wandering Xiao's column