use mysqldump to just dump the schema. Then edit the script to change the database name and pump it back into mysql.
=C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * ----- Original Message ----- From: "Darryl Hoar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 03, 2003 9:49 AM 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]