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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
