1、安装工作
cd /usr/local/software
yum install -y glib2-devel zlib-devel pcre-devel
wget https://launchpad.net/mydumper/0.9/0.9.1/+download/mydumper-0.9.1.tar.gz
tar -xzvf mydumper-0.9.1.tar.gz
cd mydumper-0.9.1
cmake .
make && make install
2、
time /root/mydumper-0.9.1/mydumper -u root -p dsideal -h 10.10.6.199 -P 3306 -T t_resource_base --less-locking --no-schemas --verbose 3 --compress -B dsideal_db -o /usr/local/bak/
数据的备份
[root@localhost tmp]# time mydumper -B aa -u root -o /tmp/sqlbak
real 0m13.726s
user 0m3.181s
sys 0m1.291s
数据的还原
[root@localhost tmp]# time myloader -u root -d /tmp/sqlbak -B aa
real 0m30.528s
user 0m2.903s
sys 0m1.604s