开发者

how to create a file of mysql database schema?

开发者 https://www.devze.com 2023-01-09 01:17 出处:网络
I need some help about how to dump only database schema, not the data. Our database already has data.But i want to create a database

I need some help about how to dump only database schema, not the data.

Our database already has data.But i want to create a database dump only for schema with out data.

I think mysqldump dumps schema a开发者_JAVA技巧long with data. Are there any options i can specify which will let me to dump schema without data.


mysqldump --no-data DATABASENAME

Or use MysqlAdministrator, phpMyAdmin or any other tool.

0

精彩评论

暂无评论...
验证码 换一张
取 消