problem importing data into older mysql version

Posted by conandor on Stack Overflow See other posts from Stack Overflow or by conandor
Published on 2010-04-05T02:53:44Z Indexed on 2010/04/05 3:03 UTC
Read the original article Hit count: 470

Filed under:

I dump data from MySQL version 5.1.30 from server 1

# mysqldump mydb1 > mydb1.sql

Then I import it to server 2 which have MySQL version 5.1.24-rc However I got an error important halfway.

# mysql mydb1 < mydb1.sql 
ERROR 1064 (42000) at line 1984: 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 ''9012345678' at line 1

Any idea how I can solve it?

© Stack Overflow or respective owner

Related posts about mysql