problem importing data into older mysql version
- by conandor
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?