My database has 3 tables: table1, table2 and table3
I would like to do a mysqldump on this database with the following conditions:
- Dump structure for all tables
- Only dump data for table1 and table2, ignore data in table3
Currently, I do this with 2 mysqldump statements
mysqldump -u user -p -d db > db_structure.sql
mysqldump -u user -p db --ignore-table=db.table3 > table1_and_table2_data.sql
Import them in the same order they were dumped (structure, then data from table1 and table2)
Is there a way to combine this into a single mysqldump command?