mysql - How to mysqldump some tables without data? -
i have 1 solution here: first, dump structure data of tables excluding tables; then, dump structure of 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 there better way solve 1 dump statement?
Comments
Post a Comment