MySQL import error caused by USING BTREE

An error occurred while importing SQL scripts using mysql in the latest project.

MySQL import script command

Mysql-u username-p dbname <dbsql. SQL

Failed several attempts. As you are not familiar with the command line in Linux, try phpMyAdmin. the following error occurs when running the SQL script after installation:

ENGINE = InnoDB AUTO_INCREMENT = 72 default charset = utf8' at line 11

After asking Google, I thought it was an error caused by different default language styles in the version, so I changed the code

ENGINE = InnoDB COLLATE = 'utf8 _ general_ci'

After phpMyAdmin runs the SQL statement, an error still occurs. However, this time, the SQL statement exits at the Create Table position of a Table, and then compares the SQL statement of this Table with the SQL statement of other tables to find the USING BTREE, at this time, my reaction was caused by it. Run the SQL statements before and after the table separately. That's right !! This proves the previous ideas. Next, it's easy to look for using btree mysql. You will see many such examples. We don't know using btree before mysql 5.14. There are two solutions:

1. Directly Delete USING BTREE

2. enable compatibility mysqldump-compatible = mysql40 when exporting scripts

The following links about using btree:

Using btree mysql

Http://stackoverflow.com/questions/3767753/mysql-error-using-btree

About using btree Bug http://bugs.mysql.com/bug.php? Id = 25162

Source: http://www.radys.cn/archives/733.html