Linux Zip command implements export data and compresses commands

Normal export data using the mysqldump command

The code is as follows	Copy Code
Mysqldump-u root-p youdatabase tabename1 tablename2 > db.sql;

Export tablename1 and Tablename2 tables in Db.sql.

The code is as follows	Copy Code
Zip-r filename.zip file1 file2 file3/usr/work/school

The above command compresses the contents of the File1, File2, File3, and/usr/work/school directories (assuming this directory exists) and puts them into the Filename.zip file.

Decompression: Unzip Filename.zip

MySQL Database export

Perform the following command export.

The code is as follows	Copy Code
./usr/local/mysql/bin/mysqldump-u root-p123456 Zhumaohai | gzip >/home/backup/zhumaohai.sql.gz

If all data is exported, the statement is:

The code is as follows	Copy Code
1./usr/local/mysql/bin/mysqldump-u root-p123456--all-databases | gzip >/home/backup/all.sql.gz

Where: root is the database user name

123456 is the corresponding root database password
Zhumaohai is the name of the database that needs to be exported.
/home/backup/zhumaohai.sql is the path to the database file SQL export.

MySQL Database import

Perform the following command import.

The code is as follows	Copy Code
1.gunzip

Import all databases:

code is as follows	copy code
1.gunzip