How to copy a schema

[dave755]

I have developed an application around a mySQL database.

Naturally, as development has proceeded, the schema of the database has mutated away from my original design. Therefore, I no longer have a SQL script that describes how to create this database and all of its tables.

My next step is to install copies of this application on several new servers. I only want the schema of the database - the test data that is in the current DB is not interesting for production use.

So, my question is: Is there a way in mySQL to automatically generate a SQL script that will reproduce my database? It would be even better if the script were editable so that I can go in and comment it.

Thanks.

Dave Gee

 

[tshot]

try mysqldump -d or mysqldump --no-data




----------------
ur feedback is a very welcome desire