MySQL Backup and recovery

Data backup

Backup command: mysqldump export data from the database to a logical backup as an SQL statement

Format:

Mysqldump-uroot-p123456-s Multi-instance Mysql.sock database name >/The file name of the backup #单库备份
Egrep-v ' #|\*|--|^$ '/backup file name    #检查备份的结果

Recover data:

Mysql-u User name-p password Library name </backup file name #把备份的文件导入mysql

Parameters of the Mysqldump

-B Library name #在备份文件里增加创建数据库和进入数据库的命令 Plus-B can be restored directly even if the database is dropped

Mysqldump-uroot-p123456-s/Multi-instance mysql.sock-b table name >/backup file #备份
Mysql-uroot-p123456-s/Multi-instance Mysql.sock < backup files #恢复

MySQL Backup and recovery