Hi Darryl, Why not use mysqldump --no-data [database] [table1] [table2] ...
John Griffin -----Original Message----- From: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 10:49 AM To: [EMAIL PROTECTED] Subject: copying Greetings, in my last email nobody tackled the schema copy issue. Here is what I need to do: I have a live database that contains several tables. I need to create a history database with the same tables (without the data). I would like to do this without manually creating all the tables in the history db. Is there a more automated way to do this? thanks in advance, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]