mysqldumper 多线程导出导入数据

分类: 文章 • 2022-09-05 12:57:05

tar -xvf mydumper-0.9.1.tar.gz
cd mydumper-0.9.1
cmake .
make
make install

mydumper --socket=/home/mysql/my3306/run/mysql.sock -u root -p Pxxx --threads=16 -B xhh_site_hd -o /u01/backup/dump/xhh_site_hd
myloader --socket=/home/mysql/my4407/run/mysql.sock -u root -p Pxxx --threads=16 -d /u01/backup/dump/xhh_site_hd