Mysql – ERROR when restoring MySQL data dump

MySQL

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.&lt' 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

Best Answer

Looks like an unescaped apostrophe error to me. Just find it, fix it, then go on to the next one and hope there aren't too many.

Related Solutions

Windows – Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

The error you received means:

MySQL error code 121: Duplicate key on write or update

Your key/constraint names must be unique across the entire database.

To resolve the issue, choose a different name for the key which has the same name as an existing key, or rename the existing key.

Mysql dump restoring

It may well be worth installing, on another box if required, mysql 5.0.77, restoring, and then re-dumping with the appropriate options.

This isn't an elegant solution, but if you're in "big trouble" and need something that works and fast, this is the first thing that jumped into my mind.

Related Topic