Joomla: migrate content from Joomla 1.5 to Joomla 1.7

This article is sharing how to migrate your Joomla 1.5 content to Joomla 1.7.

As Joomla 1.5 and Joomla 1.7 come with different structure, you might found out it is difficult to upgrade your Joomla directly from application source. However, you may upgrade the content from back-end.

First of all, you need to ensure the database prefix and assume that you are using original prefix named jos_.

To backup from Joomla 1.5,
1. Log into the PHPMyAdmin.
2. Select on SQL tab.
3. Enter this query,

SELECT `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`, `sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata` FROM jos_content

4. Select on Export from bottom.
5. Click Go to save it.

To restore to Joomla 1.7,
1. Log into the PHPMyAdmin.
2. Click on the Import button.
3. Select the file and import it.

Published by

Mick Genie

Mick Genie is the founder of and working at ExaBytes Network Sdn Bhd and WPWebHost web host company. He is expertise in Windows and Linux environment especially web hosting related information, tips and trick as well as the IT Information.