Bug #59705 Incompatible Database Dump
Submitted: 25 Jan 2011 3:03 Modified: 25 Feb 2011 4:16
Reporter: Jack Shultz Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Data Types Severity:S3 (Non-critical)
Version:5.1.52 OS:Linux (Fedora 13)
Assigned to: CPU Architecture:Any
Tags: error 1064

[25 Jan 2011 3:03] Jack Shultz 
Description:
It looks like my dump is incompatible with my current version. Is there a work around?

[boincadm@localhost ~]$ mysql hydrogen < hydrogen.sql 
ERROR 1064 (42000) at line 500: 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 '' at line 1

[boincadm@localhost ~]$ head hydrogen.sql 
-- MySQL dump 10.11
--
-- Host: localhost    Database: hydrogen
-- ------------------------------------------------------
-- Server version       5.0.77

[boincadm@localhost ~]$ mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 54
Server version: 5.1.52 Source distribution

How to repeat:
Dump database from old server and import into new server

Suggested fix:
a way to import incompatible dump
[25 Jan 2011 4:16] Valeriy Kravchuk 
What is on that line 500? Please, send/attach it to this report.

Can you make a new dump with newer version of mysqldump?
[26 Feb 2011 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".