Hi, I have two identical machines in terms of OS and software installed (more info at the end of the message).
I need to dump a database on the first machine and restore it on the second one. Here is step by step what I'm doing. ==> on server1 $mysqldump cerberus_database > cerberus_database-dump.mysql $cat cerberus_database-dump.mysql | mysql cerberus_test This works! ==> on server2 I coped the dump file to server2. The copy is good, md5 sums match. $cat cerberus_database-dump.mysql | mysql cerberus_database ERROR at line 1513: $ === Line 1513 is a very long like that starts with this: INSERT INTO thread_attachments_parts VALUES (185,198,'BM6^^K\0\0\0\0\06\0\... <cut> On both servers I have: OS: Red Hat Enterprise Linux ES release 3 Mysql: mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) This is the latest version of mysql that RedHat allows to install with up2date tool. I guess the question is why the restore succeed on server1 and fails on server2. Any comments and suggestions are highly appreciated. Thank you Peter Blajev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
