mysqldump with some tables, not using --skip-table

Question

To dump a single database I can do:

mysqldump -u root files

To dump a single table I can do:

mysqldump -u root files path

How would I dump two tables combined? Something like:

mysqldump -u root files path&path_updated

Note that I have about 50 tables, only two of which need to be exported, so I don't want to do a --skip-table on this.

Mike Brant · Accepted Answer · 2013-02-20 01:39:47Z

Just keep adding table names

mysqldump -u root files path path_updated ...

Check the documentation

Josh Austin · Accepted Answer · 2013-02-20 01:39:22Z

1

mysqldump databasename table1 table2 (Reference)

answered Feb 20, 2013 at 1:39

7763 silver badges19 bronze badges

2 Answers 2