September, 2008 | HanG321 Blog

宜家唔會星期一至五都係廣州, 當有需要先返上去. 不過home-office 既第一個星期都幾唔習慣… 超低效率, 有時唔知遊左去邊度好既就係日日都有住家飯食, 唔使成日食埋d KFC / 木桶飯 / 飯堂 / 客家菜人地廣告係”2 個禮拜減14磅”… 我估我就係加了….. 這3天假期搞了3樣野, 之前買左隻 asus wl-500w 既router, 打算 flash 就 DD-WRT 過程一波三折… 先係flash 死左 (係因為自己等左好耐好似冇反應, unplug power cord….stupid) 插lan 線有led, lan card 冇IP, ping router 就reboot. 上個月羅去代理度整, 好彩佢換過部俾我唔知佢地check 唔check 到firmware 有問題? 跟足wiki 既tutorial , step by step …

很久沒有blog, 今日中秋節補假進行一次”搬家” 其實都不是搬家, 只係將幾年前blogspot 的entry import 到 wordpress, 再將LifeType 既entry?SQL copy 到?wordpress 雖然呢個default template 有點簡單 (都唔只有點…), 過幾日有時間再搵d template Reference: 從 Blogger 轉移到 WordPress 的技巧 http://www.vixual.net/blog/archives/242 到 WordPress 的 [後台管理] -> [管理] -> [匯入] -> [部落客]。終於把lifetype 轉成 WordPress http://blog.mypage.idv.tw/?p=36 透過sql語法將資料新增到 WordPress 資料庫中

# comment
INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_content,
comment_date, comment_date_gmt, comment_author_email, comment_author_url,
comment_author, comment_author_IP)
SELECT XXX+id, YYY+article_id, normalized_text, DATE, DATE + INTERVAL - 16 HOUR,
user_email, user_url, user_name, client_ip FROM plog_articles_comments

# post
INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_modified,
post_modified_gmt, comment_count)
SELECT YYY+id, 2, DATE, DATE + INTERVAL - 16 HOUR, DATE,
DATE + INTERVAL - 16 HOUR, num_comments FROM plog_articles

UPDATE wp_posts, plog_articles_text
SET wp_posts.post_title = plog_articles_text.topic
WHERE wp_posts.ID = plog_articles_text.id + YYY

UPDATE wp_posts, plog_articles_text
SET wp_posts.post_content = plog_articles_text.TEXT
WHERE wp_posts.ID = plog_articles_text.id + YYY

# fill out guid
UPDATE wp_posts
SET wp_posts.guid = CONCAT("<a href="http://www.YourDomain.com/blog/archives/" data-mce-href="http://www.YourDomain.com/blog/archives/">http://www.YourDomain.com/blog/archives/</a>", wp_posts.ID)
WHERE wp_posts.guid = ""

# clean out [@more@]
update wp_posts set post_content=replace(post_content,'[@more@]',"");

# comment

INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_content,

comment_date, comment_date_gmt, comment_author_email, comment_author_url,

comment_author, comment_author_IP)

SELECT XXX+id, YYY+article_id, normalized_text, DATE, DATE + INTERVAL - 16 HOUR,

user_email, user_url, user_name, client_ip FROM plog_articles_comments

# post

INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_modified,

post_modified_gmt, comment_count)

SELECT YYY+id, 2, DATE, DATE + INTERVAL - 16 HOUR, DATE,

DATE + INTERVAL - 16 HOUR, num_comments FROM plog_articles

UPDATE wp_posts, plog_articles_text

SET wp_posts.post_title = plog_articles_text.topic

WHERE wp_posts.ID = plog_articles_text.id + YYY

UPDATE wp_posts, plog_articles_text

SET wp_posts.post_content = plog_articles_text.TEXT

WHERE wp_posts.ID = plog_articles_text.id + YYY

# fill out guid

UPDATE wp_posts

SET wp_posts.guid = CONCAT("<a href="http://www.YourDomain.com/blog/archives/" data-mce-href="http://www.YourDomain.com/blog/archives/">http://www.YourDomain.com/blog/archives/</a>", wp_posts.ID)

WHERE wp_posts.guid = ""

# clean out [@more@]

update wp_posts set post_content=replace(post_content,'[@more@]',"");

Archives

近況

搬家

September 2008
M	T	W	T	F	S	S
« May				Oct »
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30