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.

2 Comments

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

 

User contributed tags for this post:

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