Note:Please use the Jupgrade component for complete joomla site migration. Click here
1.Export jos_content table from old version (1.0,1.5) joomla database in sql format
2.Export xxx_content table from new version (2.5) joomla database in sql format
3.open the two sql file in text editor
[note: joomla database prefix is different in joomla2.5 and some extra fields are newly add with xxx_content]
Old version (1.0,1.5) joomla database [Old.sql]
CREATE TABLE `
jos_content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',............................
INSERT INTO `
jos_content` (`id`, .......................................
New version (2.5) joomla database [New.sql]
CREATE TABLE `
q2c_content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',............................
some extra fields................
INSERT INTO `
q2c_content` (`id`, .......................................
4. Copy the CREATE TABLE`q2c_content` (..............); query from [New.sql]
5. replace the [Old.sql] CREATE TABLE query
6. [Old.sql] Change table prefix [INSERT INTO table jos_content] to [INSERT INTO table q2c_content]
7. now drop table xxx_content from joomla database
8. import the [Old.sql]
9. after that create article categories
[jos_categories and jos_section totally differ from old and new joomla version]