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.