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 what the control console is - it sounds like a gui, maybe using a windows client? We have access only to a command-line interface over a telnet connection. Thanks again to everyone for their suggestions! Pris > -----Original Message----- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 11:39 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: How to export db or table structure? > > > > 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 separate machine. > > > > I know I can do a show tables on the existing db, and also > a describe on > > those tables, so I know what the table structure looks > like. I am trying to > > avoid having to re-type the create table statements for each table. > > > SHOW CREATE TABLE tablename; > > This can also easily be done from the MySQL Control Console. > Tools > Show > Create > Execute will generate the necesary CREATE TABLE statement. > > A question for anyone else: Is there a means of using SHOW > CREATE TABLE that > will return CREATE TABLE statements for every table within a database? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
