Right syntax to use near & #39; using btree) ENGINE = InnoDB default charset = utf8 & #39; at line 6, btreeinnodb

Right syntax to use near 'using BTREE) ENGINE = InnoDB default charset = utf8' at line 6, btreeinnodb

When navicat for mysql 10.0.10 is used to restore the database backup generated on the server to the local database, the following problems occur:

[Err] 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

) ENGINE = InnoDB default charset = utf8' at line 6

View Mysql version: mysql -- version

Server database version: mysql Ver 14.14 Distrib 5.6.19, for Linux (x86_64) using EditLine wrapper

Local Database Version: mysql Ver 14.12 Distrib 5.0.37, for Win32 (ia32)

It may be caused by incompatibility between versions;

However, this operation was normal before, but it won't work this time!

After some troubleshooting, the index caused the following problems:

Delete the indexes in the table, back up the indexes, and restore them locally. The problem is solved.