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
- Open your database file (unzip if need).
- Find and delete all USING BTREE in the content.
- Go phpMyAdmin then import again.