TRUNCATE TABLE wp_comments;
TRUNCATE TABLE wp_links;
TRUNCATE TABLE wp_postmeta;
TRUNCATE TABLE wp_posts;
TRUNCATE TABLE wp_term_relationships;
TRUNCATE TABLE wp_term_taxonomy;
TRUNCATE TABLE wp_terms;
INSERT INTO wp_terms (term_id, `name`, slug, term_group)
SELECT
d.tid, d.name, REPLACE(LOWER(d.name), ' ', '-'), 0
FROM dp_term_data d
INNER JOIN dp_term_hierarchy h
USING(tid)
;
INSERT INTO wp_term_taxonomy (term_taxonomy_id,term_id, taxonomy, description, parent)
SELECT
d.tid `term_id`,
d.tid `term_id`,
'category' `taxonomy`,
d.description `description`,
h.parent `parent`
FROM dp_term_data d
INNER JOIN dp_term_hierarchy h
USING(tid)
;
INSERT INTO
wp_posts (id, post_date, post_content, post_title,
post_excerpt, post_name, post_modified)
SELECT DISTINCT
n.nid, FROM_UNIXTIME(created), body, n.title,
teaser,
REPLACE(REPLACE(REPLACE(REPLACE(LOWER(n.title),' ', '-'),'.', '-'),',', '-'),'+', '-'),
FROM_UNIXTIME(changed)
FROM dp_node n, dp_node_revisions r
WHERE n.vid = r.vid
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id)
SELECT nid, tid FROM dp_term_node;
UPDATE wp_term_taxonomy tt
SET `count` = (
SELECT COUNT(tr.object_id)
FROM wp_term_relationships tr
WHERE tr.term_taxonomy_id = tt.term_taxonomy_id
);
INSERT INTO wp_comments (comment_post_ID, comment_date, comment_content, comment_parent, comment_author, comment_author_email, comment_author_url, comment_approved)
SELECT nid, FROM_UNIXTIME(timestamp), comment, thread, name, mail, homepage, status FROM dp_comments;
UPDATE `wp_posts` SET `comment_count` = (SELECT COUNT(`comment_post_id`) FROM `wp_comments` WHERE `wp_posts`.`id` = `wp_comments`.`comment_post_id`);
UPDATE wp_posts SET post_content = REPLACE(post_content, '', '');
UPDATE wp_posts SET post_content = REPLACE(post_content, '"/sites/default/files/', '"/wp-content/uploads/');
最近评论