I am getting the following error when attempting to restore a MySQL data dump to a different server and a different MySQL version ...
ERROR 1064 (42000) at line 14165: 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 'm telling everyone.<' at line 1
Source of dump file ...
- linux server
- MySQL v 5.1.22
- mysqldump -u UserName -p DBname | gzip > DUMPname.sql.gz
Destination ...
- linux server
- MySQL v 5.1.35
- cat DUMPname.sql.gz | gunzip | mysql -u UserName -p DBname
This dump will restore fine on the origin server.
It's large (25 gig) which makes it hard for me to research the dump file.
Any suggestions ???
Thanks Jeff