Please ignore my first mail. I got the answer in next email.

Regards,

-----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]

Reply via email to