MySQL database export and import under Linux and daily backup

of the MySQL databaseExport

1. Export the database as a SQL file

Mysqldump database name-uroot-p > XXX.SQL Export data table structure and data

eg. Mysqldump cloudres-uroot-p > Cloudres.sql

2. Export to GZ compressed file

Mysqldump Database name-uroot-p | gzip > xxx.sql.gz

3. Importing SQL files

First build a database with the same name in the database, and then execute the following command to import

Mysql-uroot-p Database name < Xxx.sql

4. If the exported. sql file is on the server, you need to download the. sql file to the server you want to import using the SCP command

SCP [email protected]:/opt/cloudboot/data/back/db/xxx.sql.gz/tmp (copy remote files to your own/tmp temp file)

MySQL database export and import under Linux and daily backup