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.