Mysql 1064 USING BTREE

Export files from the server using the mysqldump command

When importing data to another database, the following message is displayed:

MySQL returns:

#1064-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 'using BTREE,
KEY 'authorid' ('authorid') using btree,
KEY 'dateline '('datel' at line 24

 

The mysql version is found to be a problem. The imported database is server version: 5.0.18, And the exported database is 5.1.45.

Open the exported mysql file and find a file similar
KEY 'authorid' ('authorid') using btree,
Modify
KEY 'authorid' using btree ('authorid ')

Re-import and solve the problem.

 

Author: gypsum doll"