Right syntax to use near ' USING BTREE] engine=innodb DEFAULT Charset=utf8 ' at line 6

When you use Navicat for MySQL 10.0.10 to restore a database backup that is generated on a server to a local database, the following issues occur:

[ERR] 1064-you has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use the 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)

Presumably there may be incompatibilities between versions;

But before this operation is no problem, this time it is not!

After some troubleshooting, it is the index caused by the problem:

The problem is resolved by removing the index from the table, then backing it up, and then restoring it locally.

Right syntax to use near ' USING BTREE] engine=innodb DEFAULT Charset=utf8 ' at line 6