Ask

I get an error message when import database from bakup file in phpMyAdmin.

MySQL said:  
#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 AUTO_INCREMENT=13' at line 11...


Answer

  1. Open your database file (unzip if need).
  2. Find and delete all USING BTREE in the content.
  3. Go phpMyAdmin then import again.