3

I already have one solution here: first, dump the structure with data of all tables excluding some tables; then, dump the structure of those excluded tables without data.

For example:

mysqldump -uroot -ppassword database_name --ignore-table=sils.zone > test.sql;
mysqldump database_name table_name -d >> test.sql;

But is there any better way to solve this with only one dump statement?

Pang
  • 9,564
  • 146
  • 81
  • 122
fcbflying
  • 693
  • 1
  • 7
  • 23

0 Answers0