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]

Reply via email to