开发者

how to create a file of mysql database schema?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜