Tarotoast’s Stuff

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

This entry was posted on Saturday, December 30th, 2006 at 5:52 pm and is filed under Joomla, Server Diary, lmj.tw. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.