mydumper 安装部署 数据库备份用
第一步下载需要的压缩包地址
https://launchpad.net/mydumper/+download

第二步 准备环境
安装依赖 ：
yum -y install glib2-devel mysql-devel zlib-devel pcre-devel zlib gcc-c++ gcc cmake
解压安装包
tar zxf mydumper-0.9.1.tar.gz
移动改名
mv mydumper-0.9.1 /usr/local/mydumper
进入
cd /usr/local/mydumper
编译安装
cmake .
make && make install
使用的时候会报error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such错 解决办法

find / -name ‘libmysqlclient*’

ln -s /usr/local/mysql/mysql-8.0.12/library_output_directory/libmysqlclient.so.21 /usr/local/lib/libmysqlclient.so.21

vi /etc/ld.so.conf

/usr/local/lib #写入
完成之后查看一下

/sbin/ldconfig -v

备份方法
mydumper -u dbuser -p dbpassword -B dbname -o Directory to store
恢复方法
myloader -u dbuser -p dbpassword -B dbname -d Directory of storage