This post updates a previous one on the same topic.
If for some reason you need to restore a MySQL dump of an instance of Joomla (made with eBackup) with the extra component JXplorer, well you could find useful this pre import script I wrote.
Tag Archive for 'MySQL'
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).
If for some reason (sad or stupid reasons, you have a choice) you need to import into MySQL 3.x a dump made with phpMyAdmin of a MySQL 5.x DB of Joomla 1.0.x, don’t forget to change the closing sequence of the tables as:
+) ENGINE=MyISAM AUTO_INCREMENT={n} DEFAULT CHARSET={c} AUTO_INCREMENT=2 ;
-) TYPE=MyISAM AUTO_INCREMENT={n};
where {c} and {n} are given, of course.