how to create a file of mysql database schema? -


i need how dump database schema, not data.

our database has data.but want create database dump schema out data.

i think mysqldump dumps schema along data. there options can specify let me dump schema without data.

mysqldump --no-data databasename

or use mysqladministrator, phpmyadmin or other tool.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -