Search code examples
mysqljoomlamysql-error-1064joomla2.5

Joomla database Export Issue

When ever i export the DB & migrate the db to another host, while importing im getting mysql error each time. Particularly issue in in importing Usergroup table.

    #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=9' at line 17
Solution

  • I got the Solution..... Export the database with "SQL compatibility mode" e.g. "MYSQL40" and import the database with the same SQL compatibility mode "MYSQL40"