Joomla 1.1.0 alpha 2 to 1.5.0 beta

Dec 30, 2006 by tarotoast    1 Comment     Posted under: Joomla, lmj.tw, Server Diary

The 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 不過現在還長的真醜，晚點來把網頁美化。

Got anything to say? Go ahead and leave a comment!