Mikhail Berman wrote:
Hi Ravi,
If you are working with one of *NIX, you can try to use
$mysqldump --no-data DB1 tblname | mysql DB2
--no-data switch will dump only data base structure
Regards,
Mikhail Berman
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 5:47 AM
To: mysql@lists.mysql.com
Subject: How to make this work ?
Hi All,
How to make this work "CREATE TABLE DB2.tblname LIKE DB1.tblname;"
Can we have simultaneous connections with 2 DBs?
Regards,
Ravi K
Hi -
You can also do a:
CREATE TABLE newtable SELECT * FROM oldtable;
I use this often for creating backups before I run code in testing.
Thanks
-dant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
