How to mysqldump some tables without data?

861 views Asked by At

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?

0

There are 0 answers