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]