WordPress MU DNS/IP Conversion

Introduction

Lets say that you have installed WordPress MU using the directory instead of domain install (you can make only one choice and once made it is irreversible…well…not without a lot of work). Lets also assume that you have a lot of blogs up an running and you initially were only using an IP address for your server or maybe you were using a DNS name but have recently changed it to something else. None-the-less, you need to change the IP to DNS or simply rename an IP or DNS address for all posts/pages across all blogs.

What do you do?

Its a lot of work to go through ever single one of your blogs and fix every single post and page ever created. The following can help you fix up your WordPress MU settings by going into your MySQL database and making all your changes directly.

NOTE: I am making some assumptions here. I assume you are familiar with WordPress MU architecture and are comfortable with manipulating data in MySQL databases.

Setup

First, make sure you have installed PHP My Admin on your server. It is fairly straight forward to setup and use. You won’t regret it.

Backup

Once PHP My Admin is up and running, I recommend you backup the entire database before you proceed further. No need to start sweating bullets unnecessarily.

Applying the Solution

There are not many tools out there that I know of to help you in this endeavor so one must manipulate the data directly. As you know, with WordPress MU, the following table structure is created for each and every blog (each group of tables is numbered per blog ID):

All you really need to care about is the following tables of each and every blog:

• wp-posts
• wp-options

Simply export each “posts” and “options” table for each blog, do a find and replace on the IP or DNS name you want to change by using your favorite text editor, and then import the new tables back into your database.

The only other too tables you need to perform these same changes on is the following WordPress MU specific tables:

• wp-site
• wp-blogs

That is it, you are done!

Tags: WordPress MU

No comments yet.

Leave a comment

You must be logged in to post a comment.