mydumper数据库备份工具使用

mydumper备份工具

下载并安装mydumper

rpm -ivh mydumper-0.12.3-3.el7.x86_64.rpm

备份数据库

mydumper -h 192.168.100.1 -P 3306 -u root -p '*********'  --trx-consistency-only --verbose 3 --regex '^(?!(mysql|test|iNformation_schema|performance_schema|sys))' --chunk-filesize 128 -G -R -E -t 16  -o /data/backup/mysql_data/data --logfile=/data/backup/mysql_data/log/dumper.log

恢复数据

myloader -u root -a -P 3306-h 192.168.100.1 -e -o --directory /data/backup/mysql_data/data --threads 16 --verbose 3 --logfile=/data/backup/mysql_data/log/loader.log

详细参数参考文档

https://www.modb.pro/db/34039