[mysqldump]
host=localhost
port=3306
user=root
password=密码
default-character-set=utf8mb4
mysqldump --defaults-extra-file=my.cnf --single-transaction --databases 数据库名 > bak.sql
#--single-transaction 备份时不锁表
mysql -u root -p fd_xiaopai < /var/log/mysql/bak.sql
# gzip解压
gunzip -c exam.gz > db.sql
#还原
./mysql -u root -p test < ./db.sql