Backup of MySQL

Usemysqldump Command

Backup:
    

1. # mysqldump -u root -p test > mysql_backup_201411202.sql  

follow the prompts to enter the password, which willTestdatabase All table structure and data backup tomysql_backup_201411202. SQL, if the amount of data is large, you canUsegzipto compress the data, the command is as follows:
    

1. # mysqldump -u root -p test | gzip > mysql_backup_201411202.sql.gz

Backup to a remote machine, using - H specified, such as

1. # mysqldump -u root -p test > mysql_backup_201411202.sql -h xxx.xxx.xxx.xxx 

can be backed up directly toIPaddress isxxx.xxx.xxx.xxxof the remote computer.
when the system crashes, rebuilds the system, or recovers the database, you can recover the data like this:
   

1.  # mysql -u root -p test < mysql_backup_201411202.sql

To restore directly from a compressed file:
    

1. # gunzip < mysql_backup_201411202.sql.gz | mysql -u root -p test

Online data collation

From for notes (Wiz)

Backup of MySQL