MySQL > alter database;

  1. Specify a directory to store SQL files.C:\Users\chengh\Desktop(I was specified in ‘My desktop ‘)
  2. Export database:Mysqldump -u username -p database name -p port number > export file nameAs I typed the command line:mysqldump -u root -p eva -P 3306 > eva.sql(Press Enter, enter MySQL password)
  3. Export the table specified in the database: space after the database nameAdd the name of the tableCan beMysqldump -u username -p database name -p port number > export file nameSuch as:mysqldump -u root -p eva sys_user -P 3306 > user.sql 　
  4. You will seeC:\Users\chengh\Desktop*. SQL is automatically generated under the folder

MySQL > alter database;

  1. Connect to database:Mysql -u {username} -pEnter and enterpassword mysql -u root -penter
  2. Specify the target database name:Use {library name} use evaenter
  3. The import fileSource {path} source C:\Users\chengh\Desktop\user.sqlThe thing to watch out for is that you have toThere is this fileIf not, it will be reportedabnormal

MySQL backup and restore are performed using mysqldump, MySQL and source commands.