Creating a MySQL schema from an existing database
Here's a handy command to create a MySQL db schema from an existing database:
The "no-data" option stops db data from being output to the file so that only
mysqldump --no-data mydb > mydb.sqlThe "no-data" option stops db data from being output to the file so that only
DROP TABLE and CREATE TABLE lines are output. I found this tip by searching for export MySQL database; I couldn't easily find what I was looking for at the MySQL reference pages.

0 Comments:
Post a Comment
<< Home