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 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. Is there some kind of export command that will export that info to a file without the contents of the tables themselves? The current MySQL server version is 3.23.2-alpha-log. It is running on SunOS 5.6 (i386). If it matters, the new box will be a dual proc linux server, probably running RedHat 6.x or 7.x. We want to start with an empty database on that box. Sorry if this is a faq, but I didn't see it listed anywhere. Pris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
