I have a lot of WordPress sites I manage and I’ve been thinking about converting them to WordPress MU sites to consolidate management. Today I attempted the first one, about.Scriblio.net. There’s no proper way of doing it that I found, but here’s what I did:

• Create a new site in MU
• Create the users in the correct order (user ID numbers must match)
• Replace the posts, postmeta, comments, terms, term_taxonomy, and term_relationship tables with those from the original blog
• Copy the contents of wp-content/uploads to wp-content/files
• Update the posts table with the new path (both for regular content and attachments, see below)
• Hope it all worked

Somebody is likely to say “just export the content in WordPress XML format and import it in the new blog,” but that person doesn’t use permalinks based on post_id. Doing the export/import dance destroys post_id-based permalinks, and that’s a bad thingâ„¢.

The MySQL queries to update the posts with the new upload location:

• for “regular content”

  UPDATE {new_posts_table}
  SET post_content = REPLACE(post_content, '/wp-content/uploads/', 'scriblio.net/wp-content/files/')
  WHERE post_content LIKE '%/uploads/%'

• for the attachments

  UPDATE {new_posts_table}
  SET guid = REPLACE(guid, '/wp-content/uploads/', 'scriblio.net/wp-content/files/')
  WHERE guid LIKE '%/uploads/%'

Posted June 5, 2008 by Casey Bisson
Categories: Technology. Tags: conversion, mu, site management, upgrading, wordpress, WordPress MU.

1 Comment(s)

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

 

User contributed tags for this post:

about (4) - WPMU 2.6 sites (3) - where is user ID number in WP 2.6 (2) - wpmu replace wp (2) - intaling wpmu on centos (2) - wordpress mu import (2) - wordpress import wordpress mu mysql (2) - link: www.arab-sex.com (2) - how to export wordpress to wp-mu? (1) - www.sex.mu (1) - how to import posts and pics in a wordpress mu blog (1) - WPMU based site for private accommodations (1) - import wordpress into wpmu (1) - change wp to wpmu (1) - wordpress mu import users (1) - how to replace an existing site with wpmu? (1) - Upgrading from WP to WPMU (1) - wordpress mu sites (1) - import to mu wordpress 2.6 (1) - convert wp wpmu (1) - guid wordpress mu (1) - import regular wp blog in wp mu (1) - exporting users to wordpress mu (1) - wordpress mu export import (1) - wpmu to replace wordpress (1) - link: www.sex.tv.com (1) - convert wordpress to wpmu (1) - export wordpress.org to mu wordpress (1) - wordpress mu import posts (1) - import wordpress mu (1) - Wordpress export users (1) - WP 2.6.2 site doesn't open in IE (1) - import wordpress wpmu (1) - CONVERTING WP TO XML (1) - importing content to wpmu blog (1) - from regular wp to wpmu (1) - wpmu import blog (1) - www.sex mu (1) - permalinks wpmu (1) - permalinks plugin wpmu (1) - wordpress to wordpress mu export import permalink (1) - wpmu import plugin attachment (1) - export wordpress to wpmu (1) - wpmu import wordpress (1) - wordpress mu import categories (1) - create a new blog with wordpress mu (1) - wp 2 wpmu (1) - wp-mu to wp (1) - wordpress mu (1) - content (1) - upgrading from wordpress to wpmu (1) - upgrading to wordpress MU (1) - converting wordpress to wordpress mu (1) - export users into Wordpress mu (1) - using democracy with wpmu (1) - import wp users wpmu (1) - wpmu download and i port file attachments (1) - move wordpress mu to new site (1) - wpmu export blogs (1) - wpmu create category (1) - wpmu mysql searc replace (1) - wpmu with wp 2.6 (1) - wordpress mu import export move photos (1) - plugin export wpmu (1) - wpmu sites table (1) - export users to wpmu (1) - www.bigpussy.comm (1) -