How to solve the using btree error prompt when importing data from mysql

The recent use of MySQL to import SQL script time error:

You have a 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;

Looking for a using btree MySQL, you will see many such examples, MySQL 5.14 version did not recognize the using Btree. There are three solutions:

1, directly remove USING btree
2. Turn on compatibility when exporting scripts mysqldump–compatible=mysql40
3, key ' ename ' (' slug ') using btree, modified to key ' ename ' using btree (' slug '), that is, put the using btree in front of the index field.

Example

Open the file you want to import search Btree find the following

UNIQUE KEY ' user_name ' (' suppliers_name ') USING btree, modified to

The UNIQUE KEY ' user_name ' USING btree (' Suppliers_name '),

The using Btree is placed in front of the index field.