An unusual management of a MySQL dump

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.

Last update: 2008-05-19

Post a Comment

Your email is never shared. Required fields are marked *

*
*