CODEWITHSUNDEEP
mysqldatabase
Tauquir
Tauquir

Reputation: 6913

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 along with data. Are there any options i can specify which will let me to dump schema without data.

Upvotes: 0

Views: 1770

Answers (1)

Andreas Rehm
Andreas Rehm

Reputation: 2232

mysqldump --no-data DATABASENAME

Or use MysqlAdministrator, phpMyAdmin or any other tool.

Upvotes: 3

Related Questions