Recently we have begun the arduous process of upgrading a site from Joomla 1.0.15 to Joomla 1.5.3. The manual upgrade from Joomla 1.0 to 1.5 is not as 'simple' as they promote. The FIRST sign of a problem is the migration component became hung - the output for the My SQL dump was corrupted. The next step, re-run the migration script ...
Sounds easy enough, and it completed with no problems. Then, import into the new Joomla 1.5 database structure. Wrong, with over 30,000 articles on our site, there were duplicate entries (according to MySQL import). So, we took apart the SQL file, and were unable to find duplicates.
So - we were left with a dilema, now, and I can not stress this enough -- do NOT tinker with your database if you are unsure of what you are doing, also the import should NOT be done on a live site, if nothing else install Joomla 1.5 into a different directory and database - the two versions are NOT compatible. Fork out a couple of dollars and have someone do this for you. Here is the solution that worked for us:
- On the Export tab of your My SQL database - select jos_content, jos_categories & jos_sections, uncheck structure, under data place a check in use IGNORE into.
- Export the current contents of jos_content (substitute jos if your db uses a different prefix)
- Save this as a .gz zipped file, in a directory that you can find again easily.
- On the Joomla 1.5 database, import the MySQL file - the "Ignore Into" will supress any errors, so you must manually check the data, and preview on the development site.
Remember, we are not telling you to do anything here - you do this, you are on your own, we are simply sharing what worked for us. If you break your site, frak your database and break glass from the resulting frustration - we told you. No warranty or guarantee is implied or offered - use at your own risk! With that being said - good luck! Feel free to leave comments for us if you have any, we will try and help. Oh, and welcome to the new Designs Edge website!
