Introduction to Mysqldump Backup and restore database commands in MySQL

Backup data:

The code is as follows	Copy Code
Mysqldump-u User name-p password database name > Xx.sql

When the volume of data is large, you can use gzip compression

The code is as follows	Copy Code
Mysqldump-u User name-p password database name | gzip > XX.sql.gz

Recover data:

The code is as follows	Copy Code
Mysql-u User name-p password database name < Xx.sql

Recovering directly from gzip compressed files

The code is as follows	Copy Code
Gzip < XX.sql.gz | Mysql-u User name-p password database name