MySQL database full export and import

If your MySQL database is relatively small, we can export it every month. We can use it to recover quickly when there are some unrecoverable errors in this database.

Linux complete export of the database in

mysqldump–uroot–p--database Database name >/yscf/download/yscf220150429.sql

Enter Password:mysql the password

SQL Import of the database :

mysqldump–uroot–p Database name < Data Name . SQL This statement does not see the progress of the execution.

The following code can see the progress:

Mysql–uroot–p

Mysql>source file path / Database name . SQL

MySQL database full export and import