Blog Conversion – pLog to WordPress

To convert database from pLog to WordPress, you basically need to run 2 SQL queries, assuming you have them on the same server.

<br /> # Posts<br /> INSERT INTO db_wordpress.wp_posts<br /> (<br /> ID,<br /> post_author,<br /> post_date,post_date_gmt,<br /> post_content,post_title,<br /> post_modified,post_modified_gmt<br /> )<br /> SELECT<br /> a.id,<br /> 1,<br /> FROM_UNIXTIME(UNIX_TIMESTAMP(a.date)),<br /> FROM_UNIXTIME(UNIX_TIMESTAMP(a.date)+5*3600),<br /> p.text,p.topic,<br /> FROM_UNIXTIME(UNIX_TIMESTAMP(a.date)),<br /> FROM_UNIXTIME(UNIX_TIMESTAMP(a.date)+5*3600)<br /> FROM db_plog.plog_articles_text p,db_plog.plog_articles a<br /> WHERE a.id=p.article_id</p> <p># Post-Categories Relationship<br /> INSERT INTO db_wordpress.wp_post2cat (post_id,category_id)<br /> SELECT r.article_id,r.category_id FROM db_plog.plog_article_categories_link r<br />