RE: How to export db or table structure?

2003-07-25 Thread Priscilla Walther
Hi Jim - Thanks for the suggestion. It appears that show create table tablename may not be supported on the MySQL version I am running. However, someone else suggested mysqldump -d, which I used to do exactly what you mentioned - dump the create statements for all the tables in a db. Not sure w

How to export db or table structure?

2003-07-25 Thread Priscilla Walther
Hi All - I'm a newbie to the database area, but have inherited a MySQL database to manage along with my development duties. We have a very large MySQL database, and the designer of the database no longer works for us. I need to re-create the same table structure, but without the content, on a se