mysql数据库备份策略_MySQL备份策略（四）：mydumper备份数据库

1.mydumper安装

[root&＃64;localhost ~]# tar xf mydumper-0.9.1.tar.gz -C /usr/local/src //上传mydumper源码包后解压

[root&＃64;localhost src]# ls

mydumper-0.9.1

[root&＃64;localhost ~]# cd /usr/local/src/mydumper-0.9.1/

[root&＃64;localhost mydumper-0.9.1]# yum install gcc gcc-c&＃43;&＃43; make cmake -y //部署环境&＃xff0c;解决依赖关系

[root&＃64;localhost mydumper-0.9.1]# yum install glib2-devel mysql-devel zlib-devel pcre-devel -y

[root&＃64;localhost mydumper-0.9.1]# cmake . //执行完后ls&＃xff0c;存在CmakeCache.txt&＃xff0c;需要手动删除rm -rf CmakeCache.txt

[root&＃64;localhost mydumper-0.9.1]# make

[root&＃64;localhost mydumper-0.9.1]# make install

2.备份

备份文件

[root&＃64;localhost mydumper-0.9.1]# mydumper -u root -p Sirius123! -B db0122 -o /mysqlbak //备份

[root&＃64;localhost mydumper-0.9.1]# mydumper -u root -p Sirius123! -B db0122 -c -o /mysqlbak //备份同时压缩

备份表

[root&＃64;localhost mydumper-0.9.1]# mydumper -u root -p Sirius123! -B db0122 -T t1 -o /mysqlbak/tables

[root&＃64;localhost mydumper-0.9.1]# mydumper -u root -p Sirius123! -B db0122 -T t2,t3 -o /mysqlbak/tables

3.恢复

恢复文件

[root&＃64;localhost mydumper-0.9.1]# myloader -u root -p Sirius123! -B db0122 -o -d /mysqlbak/

恢复表

[root&＃64;localhost mydumper-0.9.1]# myloader -u root -p Sirius123! -d /mysqlbak/tables -o -B db0122