go-mydumper
go-mydumper copied to clipboard
xelabs
Q: can it support only dump some specific tables?
I have the following questions?
-
Can it support only dump some specific tables?
-
Can it only dump the data without the schema sql, and then load the data into database via myloader?
I have the following questions?
- Can it support only dump some specific tables?
No, it's database based.
- Can it only dump the data without the schema sql, and then load the data into database via myloader?
No.
Do you have any plan to support this feature? repository(https://github.com/maxbube/mydumper) seems support this feature but without supporing where condition.
No plans yet, but it will be easy to do. BTW, which of these two do you prefer? I will take priority.
2 has high priority than 1.
BTW , for 1 , I see the code cmd/config.go, and try add table = trainee_sub_center_info,trainee_center_info in [mysql] section, then run the mydumper, only those two tables are dumped. Does the tool already support 1st question?
can the tool ignore some columns when dump the data?
No, but it easy to do.
ignore columns done: https://github.com/xelabs/go-mydumper/commit/975a1b0cacc00f476994ad9982a1cc98480882f5
And more details to see: https://github.com/xelabs/go-mydumper/blob/master/conf/mydumper.ini.sample
Thanks for your quick response. and looking forward to the feature (dump the data without schema and load the data into database).
@BohuTANG, Is the feature(dump data without the schema sql, and then load the data into database via myloader) in your plan?
@BohuTANG, Is the feature(dump data without the schema sql, and then load the data into database via myloader) in your plan?
Not yet.
@BohuTANG, Is the feature(dump data without the schema sql, and then load the data into database via myloader) in your plan?
Not yet.
Will you plan support this feature?
@BohuTANG same question does the feature(dump data without the schema sql, and then load the data into database via myloader) in your plan?