The index in the backup file is not syntactically formatted
Restore operations from MySQL backed up SQL files The Times are wrong, check the error log, as follows:
Error Code: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 auto_increment=50913 DEFAULT CHARSET=GBK ' at line 21
The reasons are as follows:
Source code in the export file:
PRIMARY KEY (' row_id ') USING BTREE,
UNIQUE KEY ' Columnaindex ' (' ColumnA '),
KEY ' Columnbindex ' (' columnb ') USING HASH,
KEY ' Columncindex ' (' COLUMNC ') USING BTREE,
...
The correct wording:
PRIMARY KEY USING BTREE (' row_id '),
UNIQUE KEY ' Columnaindex ' (' ColumnA '),
KEY ' Columnbindex ' USING HASH (' columnb '),
KEY ' Columncindex ' USING BTREE (' COLUMNC '),
...
By moving all index types in the export file (USING BTREE, etc.) to the front of the index column (COLUMNB, etc.), the import operation can be completed normally.
A bug in MySQL backup restore