Moving and exporting a Joomla MySQL DB via phpMyAdmin

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!

2 Responses to “Moving and exporting a Joomla MySQL DB via phpMyAdmin”


  1. 1 Pham Dinh An

    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

  2. 2 Carlo

    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.

Leave a Reply