mydumper使用.md

mydumper 常用命令

源文档

导出数据

mydumper -h 11.22.33.44 -u root -P3307 -p pAssw0rd -B myschema -t 4 -o myschema_dump/

导入数据

myloader -h <cluster_dns_endpoint> -u master -p pAssw0rd -P 3307 -B myschema -t 4 -d myschema_dump

使用mydumper docker image

源文档

# mydumper 导出
export backups=Your date dir
docker run --name mydumper --rm -v ${backups}:/backups  mydumper/mydumper:latest sh -c "rm -rf /backups/*; mydumper -h 172.17.0.5  -o /backups"
# 多库导出
docker run --privileged --name mydumper --rm  -v ${backups}:/backups mydumper/mydumper sh -c "mydumper -h 172.26.94.106 -P 3307 -u root -p pass -t 3 --regex '^(db2\.|db1\.)'  -o backups/"
# 多库，导出指定前缀表
docker run --privileged --name mydumper --rm  -v ${backups}:/backups mydumper/mydumper sh -c "mydumper -h 172.26.94.106 -P 3307 -u root -p pass -t 2 -F 200 --regex '^(db2\.t_test*|db1\.t_demo*)'  -o backups/"

# myloader 导入
docker run --name mydumper --rm -v ${backups}:/backups  mydumper/mydumper:latest sh -c "myloader -h <cluster_dns_endpoint> -u master -p pAssw0rd -P 3307 -B myschema -t 4 -d myschema_dump -d /backups"