Joomla 1.1.0 alpha 2 to 1.5.0 beta
Saturday, December 30th, 2006The meat of a site lies in the table `jos_content`. To import the old dump of `jos_content` from Joomla 1.1.0 alpha 2 into the latest 1.5.0 beta, you must take account of the new row presented in 1.5. To do this, use any text editor that has a replace string function and open up the sql dump of the `jos_content` section.
Replace ); with ,''); and save the file in UTF-8 if it contains special characters. Then simply import the file into phpmyadmin and then all the previous articles are imported.
You might have different Section/Category ID in the new Site, to update the database to reflect change:
UPDATE jos_content
SET `sectionid`=NEWID
WHERE `sectionid`=OLDID
replace `sectionid` with `catid` for categories.
雖然說昨天就把 http://lmj.tw/ 弄好了,但是忘記把 Apache 密碼拿掉,大概會被認為又沒有弄好吧.. XD 不過現在還長的真醜,晚點來把網頁美化。

Recent Comments