Migrating Mosets From Joomla 1.5 to 1.7

I havn't been able to find anywhere the instructions for migrating a mosets tree directory from Joomla 1.5 to 1.7 to I followed a guide for migrating Jomsocial which seemed to work. Firstly you upgrade the Joomla site using jupgrade. You then habe your new 1.7 site in a jupgrade sub folder like www.yourdomain.com\jupgrade. You will notice however that mosets won't be there at all.

Don't install mosets first as it will install a fresh copy with the sample data. What I worked out was go into cpanel and click on the phpMyAdmin icon. This is where you can edit the database. You'll notice the old website has tables that all start with jos_ and the new website uses the tables that start with j17_. What I did was copy the old tables, and switch all the instances of jos_ to j17_.

To do this, click on the export button and highlight/select all the tables that start with jos_mt. I had 25. No need to change any options, just export as a standard sql file. Then open the downloaded sql file with wordpad or similar and click on replace text. You need to replace everything instance of jos_ with j17_

Go back to phpMyAdmin and import the sql file. When you look at your database you'll now see all the MT tables with a j17_ prefix in there. It's at this point I installed Mosets and if any database updates needed to happen it should sort it out. I'm not sure if does make any changes though. You can now look at your new website in the jupgrade folder and click on the directory and see all the listings.

But there's some more to do. Images need to be copied from the old site to the new site as well. The old images are in components/com_mtree/img/listings and 3 folders called M O and S. I used firezilla to download the 3 folders and upload to the same path in the jupgrade folder.

If you need a hand migrating your mosets directory to Joomla 1.7 send us an email for a quote.