Update joomla article database (1.0 or1.5) to 2.5

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]