-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Nelson,
Show the command you used to backup the database from the master. The biggest caveat from replication is the server version. Your version is very very old. There have been many changes in quite a few places that are causing this error. It's basically from server version incompatibility. It is said that you can replicate up from an old master to a new slave, but there are still other issues beyond the replication handler and binary log. There is a --compatible option for mysqldump but it doesn't work on anything < 4.1. Line 544 of the mysqldump command shows this option. You can still get the data but you might have to do a little hurdle jumping to make it happen. Also look into dumping the contents into tab format or possibly starting the server in strict mode and fooling around a bit then dumping. Bryan > I have an ancient Redhat 7 with MySQL version 4.0.13 that are still using for > production. I want to setup a new machine > as a replication for the RH7. I have installed Fedora 9 with MySQL-RHEL > version 5.1.36 > > I have backup the db on RH7 using mysqldump. When I want to dump the file to > my FC9, I always got an error: > > [r...@replica backup]# mysql -uroot -p replicadb < replicadb-09052009.sql > Enter password: > ERROR 1064 (42000) at line 4: You have an error in your SQL syntax; check the > manual that corresponds to your MySQL > server version for the right syntax to use near > '------------------------------------------------------- > CREATE TABLE accou' at line 1 > > I have tried before restoring db the same way and doesn't encountered an > error. I'm just wondering if the mysql and > mysqldump version could be the problem. > > TIA, > > > Nelson > > > - -- A healthy diet includes Linux, Linux and more Linux. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkqnL6UACgkQh+MLjl5SKYT7bACeN9PkkYqsIaFTMStN7zj1WllM YI0AnAhwgatCZ0c3z+gK9l10iWpltK4x =QRz7 -----END PGP SIGNATURE----- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Linux Users Group. To post a message, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit our group at http://groups.google.com/group/linuxusersgroup -~----------~----~----~----~------~----~------~--~---
