I tried mysqldump in past but it do come INSERT statement (with DATA). Is there any option if you just need schema. I might have missed it.
Appreciate it, -----Original Message----- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 9:51 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: copying 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
