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

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -