In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.

CREATE TABLE DB2.tblname LIKE DB1.tblname;
INSERT INTO DB2.tblname SELECT * FROM DB1.tblname;

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to