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.
精彩评论