Migrating Mambo To WordPress

Due to the simple nature of the Mambo DB schema, the migration was pretty straightforward.

Here’s the sql used for the conversion which was modified from this post:

# POSTS
INSERT INTO wp3test.wp_posts
(ID, post_author, post_date, post_content, post_title, post_excerpt,
post_modified, post_type, post_status)
SELECT DISTINCT
        id `ID`,
        created_by `post_author`,
        created `post_date`,
        CONCAT(`introtext`,`fulltext`) `post_content`,
        title `post_title`,
        introtext `post_excerpt`,
        modified `post_modified`,
        'post' `post_type`,
        IF(state = 1, 'publish', 'private') `post_status`
FROM `bluebook`.mos_content



# AUTHORS
INSERT IGNORE INTO wp3.wp_users
  (ID, user_login, user_pass, user_nicename, user_email, user_registered, user_status, display_name)

SELECT DISTINCT
  id `ID`,
  username `user_login`,
  "$P$B4lhk3fR6NAs5z7weWIMJzubwhHH0/0" `user_pass`,
  name `user_nicename`,
  email `user_email`,
  registerDate `user_registered`,
  block `user_status`,
  name `display_name`

FROM `bluebook`.mos_users

;


# MOS_SECTIONS -> CATEGORIES
#wp_terms
INSERT INTO wp3test.wp_terms
  (term_id,name,slug)
SELECT DISTINCT
id `term_id`,
name `name`,
lcase(name) `slug`

FROM `bluebook`.`mos_sections`
WHERE id !=1 AND id !=2


# wp_term_taxonomy
INSERT INTO wp3test.wp_term_taxonomy
  (term_taxonomy_id,term_id,taxonomy)

SELECT DISTINCT
id `term_taxonomy_id`,
id `term_id`,
lcase('category') `taxonomy`

FROM `bluebook`.`mos_sections`
WHERE id !=1 AND id !=2



#wp_term_relationships
INSERT INTO wp3test.wp_term_relationships
  (object_id,term_taxonomy_id)

SELECT DISTINCT
id `object_id`,
sectionid `term_taxonomy_id`

FROM `bluebook`.`mos_content`


# MOS_CATEGORIES -> TAGS
# Thankfully the seciondid and catid values don't match at all

INSERT IGNORE INTO wp3test.wp_terms
  (term_id,name,slug)
SELECT DISTINCT
id `term_id`,
name `name`,
REPLACE(lcase(name),' - ','-') `slug`

FROM `bluebook`.`mos_categories`

WHERE id !=1 AND id !=2


INSERT IGNORE INTO wp3test.wp_term_taxonomy
  (term_taxonomy_id,term_id,taxonomy)

SELECT DISTINCT
id `term_taxonomy_id`,
id `term_id`,
lcase('post-tag') `taxonomy`

FROM `bluebook`.`mos_categories`
WHERE id !=1 AND id !=2


INSERT IGNORE INTO wp3test.wp_term_relationships
  (object_id,term_taxonomy_id)

SELECT DISTINCT
id `object_id`,
catid `term_taxonomy_id`

FROM `bluebook`.`mos_content`


# Update tag and category counts
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
    )