I have finally spent about 3 hours time total to finish migrating my lifetype journal entries to WordPress.<\/p>\n
The next phase is the photo album, but that is not priority.<\/p>\n
Since online help fails me (broken links and missing scripts), I've done it manually via phpMyAdmin and mysql queries.<\/p>\n
Below are my summary:<\/p>\n
wordpress \u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 lifetype: plogdb<\/p>\n
ID\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0article_id
\npost_author\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0'1'
\npost_date &
\npost_date_gmt\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0plog_articles -> date
\npost_content\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0text
\npost_title\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0topic
\npost_status\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0'publish'
\ncomment_status,
\nping_status\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0'open'
\npost_name\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0topic lowercase and hyphenated
\npost_modified,
\npost_modified_gmt\u00a0\u00a0 \u00a0plog_articles -> date
\npost_parent\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0'0'
\nmenu_order\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0'0'
\npost_type\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0'post'
\nguid\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0http:\/\/nycphantom.com\/journal\/?p=ID
\ncomment_count\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0plog_articles -> num_nonspam_comments<\/p>\n
INSERT INTO `wp_posts`<\/p>\n
(article_id,post_author,post_content,post_title,post_status,comment_status,ping_status,post_name,<\/p>\n
post_parent,menu_order,post_type,guid)
\nSELECT ID,'1',text,topic,'publish','open','open',LCASE(REPLACE(REPLACE(REPLACE<\/p>\n
(topic,'\\'',''),'?',''),' ','-')),'0','0','post',CONCAT('http:\/\/nycphantom.com\/journal\/?p=',ID)<\/p>\n
FROM `plog_articles_text`<\/p>\n
UPDATE plog_articles p, wp_posts pp SET pp.post_date = p.date, pp.post_date_gmt = p.date,<\/p>\n
pp.post_modified = p.date, pp.post_modified_gmt = p.date, pp.comment_count =<\/p>\n
p.num_nonspam_comments WHERE pp.id = p.ID AND pp.id <= 2567<\/p>\n
UPDATE `plog_article_categories_link` SET category_id = 37 WHERE category_id = 1
\nUPDATE `plog_article_categories_link` SET category_id = 38 WHERE category_id = 2
\nUPDATE `plog_article_categories_link` SET category_id = 36 WHERE category_id = 3
\nUPDATE `plog_article_categories_link` SET category_id = 39 WHERE category_id = 4
\nUPDATE `plog_article_categories_link` SET category_id = 33 WHERE category_id = 5
\nUPDATE `plog_article_categories_link` SET category_id = 40 WHERE category_id = 6
\nUPDATE `plog_article_categories_link` SET category_id = 41 WHERE category_id = 7
\nUPDATE `plog_article_categories_link` SET category_id = 42 WHERE category_id = 8
\nUPDATE `plog_article_categories_link` SET category_id = 51 WHERE category_id = 9
\nUPDATE `plog_article_categories_link` SET category_id = 43 WHERE category_id = 10
\nUPDATE `plog_article_categories_link` SET category_id = 34 WHERE category_id = 11
\nUPDATE `plog_article_categories_link` SET category_id = 44 WHERE category_id = 12
\nUPDATE `plog_article_categories_link` SET category_id = 45 WHERE category_id = 13
\nUPDATE `plog_article_categories_link` SET category_id = 35 WHERE category_id = 14
\nUPDATE `plog_article_categories_link` SET category_id = 46 WHERE category_id = 15
\nUPDATE `plog_article_categories_link` SET category_id = 47 WHERE category_id = 16
\nUPDATE `plog_article_categories_link` SET category_id = 48 WHERE category_id = 17
\nUPDATE `plog_article_categories_link` SET category_id = 49 WHERE category_id = 18
\nUPDATE `plog_article_categories_link` SET category_id = 50 WHERE category_id = 19<\/p>\n
UPDATE `plog_article_categories_link` SET category_id = category_id - 30<\/p>\n
INSERT INTO `wp_term_relationships` (object_id, term_taxonomy_id, term_order) SELECT article_id,<\/p>\n
category_id, '0' FROM `plog_article_categories_link`<\/p>\n
Emptied all comments in wordpress, since all spam but 1 testing comment.<\/p>\n
INSERT INTO `wp_comments` (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_parent, user_id) SELECT id, article_id, user_name, user_email, user_url, client_ip, date, date, text, '0', '1', '0', '0' FROM `plog_articles_comments`<\/p>\n","protected":false},"excerpt":{"rendered":"
I have finally spent about 3 hours time total to finish migrating my lifetype journal entries to WordPress. The next phase is the photo album, but that is not priority. Since online help fails me (broken links and missing scripts), … Continue reading