CODEWITHSUNDEEP
mysqljoomlamysql-error-1064joomla2.5
Parthi04
Parthi04

Reputation: 1151

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

Upvotes: 1

Views: 1185

Answers (1)

Parthi04
Parthi04

Reputation: 1151

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"

Upvotes: 1

Related Questions