search

xelabs / go-mydumper

A multi-threaded MySQL backup and restore tool, faster than mysqldump
GNU General Public License v3.0
346 stars 100 forks source link

Q: can it support only dump some specific tables? #30

Open jmbkeyes opened 4 years ago

jmbkeyes commented 4 years ago

I have the following questions?

  1. Can it support only dump some specific tables?

  2. Can it only dump the data without the schema sql, and then load the data into database via myloader?

BohuTANG commented 4 years ago

I have the following questions?

  1. Can it support only dump some specific tables?

No, it's database based.

  1. Can it only dump the data without the schema sql, and then load the data into database via myloader?

No.

jmbkeyes commented 4 years ago

Do you have any plan to support this feature? repository(https://github.com/maxbube/mydumper) seems support this feature but without supporing where condition.

BohuTANG commented 4 years ago

No plans yet, but it will be easy to do. BTW, which of these two do you prefer? I will take priority.

jmbkeyes commented 4 years ago

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?

jmbkeyes commented 4 years ago

can the tool ignore some columns when dump the data?

BohuTANG commented 4 years ago

can the tool ignore some columns when dump the data?

No, but it easy to do.

BohuTANG commented 4 years ago

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

jmbkeyes commented 4 years ago

Thanks for your quick response. and looking forward to the feature (dump the data without schema and load the data into database).

jmbkeyes commented 4 years ago

@BohuTANG, Is the feature(dump data without the schema sql, and then load the data into database via myloader) in your plan?

BohuTANG commented 4 years ago

@BohuTANG, Is the feature(dump data without the schema sql, and then load the data into database via myloader) in your plan?

Not yet.

jmbkeyes commented 4 years ago

@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?

jmbkeyes commented 3 years ago

@BohuTANG same question does the feature(dump data without the schema sql, and then load the data into database via myloader) in your plan?

BohuTANG commented 3 years ago

Not yet.