If for some reason (sad or stupid reasons, you have a choice as usual) you need to restore a MySQL dump of a Joomla DB and you have experienced the same problem described here, well, you could find it useful to run this pre import script I wrote.
Update (2006-12-07): this might be needed if you use JXplorer and if you dump with eBackup (not with phpMyAdmin).
Last update: 2008-05-19
If you enjoyed this post, make sure you subscribe to my RSS feed!
White importing my sql database, i got a error:
#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 ‘DEFAULT CHARSET=utf8 AUTO_INCREMENT=3′ at line 35
Please help me, I’m so confused and don’t know what to do.
My character set is Vietnamese
I find it very hard to make hypotheses about the cause of your problem… it could be
- a missing comma or,
- as the warning states, a mismatch between the version of the exported db and the version of the db you are trying to import the dump into.