During the migration of my 3 years old Joomla!1.0 website to 1.5 something weird happened just before launcing the new site. All the data on the column "fulltext" from the table "jos_content" was lost and I couldn't identify the cause. Everything was ready and I discovered accidentaly.

Note to self -> Backup Frequently!!

To fix that I exported the "id" and "fulltext" from my old Joomla!1.0 from the database, created a new table in the new Jooml1.5 with the data from the old site and updated the data between the 2 tables. using this:

UPDATE jos_content a SET `fulltext` = (SELECT `fulltext` from jos_content_old b where a.id = b.id);

And within few seconds the table was updated :) That statement saved alot of work! Note that the a and b used just to create Alias for easy reference.

I hope I'll be writing more about that migratin in the next few days. It took me sometime cause the site was old and alot of extensions and addons needed to be upgraded. I hope you find my experience useful!

Have a nice day