mydumper/myloader

mydumper配置文件:

[mydumper]
host = 10.0.0.12
user = root
password = Forzadata1234
database = bocai
rows=10000

[`bocai`.`trainee_sub_center_info`]
where = centerId=269
[`bocai`.`trainee_center_info`]
where = centerId=264

导出269的trainee_sub_center_info,264的trainee_center_info

mydumper --defaults-file=mydumper.conf --tables-list bocai.trainee_sub_center_info,bocai.trainee_center_info --no-locks --outputdir /root/test --no-schemas --complete-insert 

导入

myloader --host 10.0.0.12 --user root --password Forzadata1234 --database bocai2 --directory ./test

 

posted on 2023-02-08 15:22  jmbkeyes  阅读(98)  评论(0)    收藏  举报

导航