Magento Import Database prompt error 1064 (42000) at

Another error occurred in the Magento Guide database:

A similar error occurred during the execution of the restored database or SQL statement:
C:mysqlbin>mysql Sq_zgzk < 1.sql-u root

Error 1064 (42000) at line 382: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
KEY ' fk_attribute_varchar_entity ' (' entity_id '),
KEY ' Fk_catalo ' at line 9

The solution is to search

The code is as follows	Copy Code
UNIQUE KEY ' idx_base ' (' entity_type_id ', ' entity_id ', ' attribute_id ', ' store_id ') USING btree Replaced by UNIQUE KEY ' idx_base ' USING btree (' entity_type_id ', ' entity_id ', ' attribute_id ', ' store_id ')

Re-import problem resolution.

If the above solution can not solve, you are from the high version to the lower version of the import we can try the following methods to solve

Reason: Because a high version of the SQL statement was imported in a lower version, it is possible to run in MYSQL4.02 with statements in the MYSQL4.1 version

Import between different versions.

Workaround: Upgrade the MySQL database to the corresponding version

Or:

The code is as follows	Copy Code
Program code Engine=myisam DEFAULT charset=latin1 or program code Engine=innodb DEFAULT charset=latin1

Replace all with program code

The code is as follows	Copy Code
Engine=myisam