change_hostname.php

<?php
/**
 * Migrates the database of a WP Network installation to a new hostname.
 *
 * This script will change the hostname of a WPMU database.
 * It requires $old_domain and $new_domain as parameters - which should
 * countain just the domain name (no http://, no leading slash, etc).
 *
 * Currently, it will:
 * ** change hostnames on the blogs table.
 * ** change hostnames on the wp_options table of each blog.
 *
 * It WILL fail in the following scenarios:
 * ** a non-network WP installation.
 * ** a network installation with multiple sites (untested).
 *
 * Please note that this will affect only the database; you will need
 * to change the wp-options file (and anything else) as needed to finish
 * the migration. Use {@link http://codex.wordpress.org/Changing_The_Site_URL}
 * as a reference.
 *
 * Can only be run on CLI. Be warry of execution time and memory limits.
 *
 * @package WP Migrations
 */

 /*
 	TODO: support path changes
 	TODO: write changes to wp-config
 	TODO: modularize stuff
 */
 	
 	
	$old_domain = 'localhost';
	$new_domain = 'test';

	if(isset($argv[1]) && isset($argv[2])){
		$old_domain = $argv[1];
		$new_domain = $argv[2];
	}
	if (isset($argv[3]))
		$new_path = $argv[3];
		die('Not implemented. Sorry.');
	
	if($old_domain == $new_domain and ! isset($new_path)){
		die("Old and new domains are the same - please specify different ones.");
	}
	
	define ('DOMAIN', $old_domain);
	define ('PATH', '/var/www/wp3');
	
	require_once('lib/utils.php');

	message( "* Migrating WP Database to '$new_domain' .") ;
	
	if (isset($new_path)) {
		step("** Changing paths on $wpdb->site ...");
		$old_path = $wpdb->get_var($wpdb->prepare( "select path from $wpdb->site 
			where domain = %s", $old_domain));
		$query = $wpdb->prepare( "update $wpdb->site set path = %s 
			where domain = %s", 
			$new_path, $old_domain);
		$wpdb->query($query);
		done();

		step("** Changing paths on $wpdb->blogs ...");
		$query = $wpdb->prepare("update $wpdb->blogs set 
			path = replace(path, %s, %s) where domain = %s",
			"/$old_path/", "/$new_path/", $old_domain);
		$wpdb->query($query);
	}

	require_once('lib/wp-load.php');

	step( "** Changing domain on $wpdb->site ...");
	$wpdb->query($wpdb->prepare(
		"update $wpdb->site set domain = %s where domain = %s", 
		$new_domain, $old_domain));
	done();

	step( "** Changing domains on $wpdb->blogs ...");
	$wpdb->query($wpdb->prepare("update $wpdb->blogs set domain=%s
		where domain = %s", $new_domain, $old_domain ));
	done();
	
	step("** Changing wp_options on all blogs... ");
	$blog_list = $wpdb->get_results("select * from $wpdb->blogs");
	foreach( $blog_list as $blog){
		// uses proper table prefixing.
		$table_name = $wpdb->prefix . $blog->blog_id . '_options';
		// the first blog may or may not use a numbered prefix.
		if((int)$blog->blog_id == 1){
			$exists = $wpdb->get_var("show tables like '$table_name' ");
			if(! $exists)
				$table_name = $wpdb->options;
		}
		
		$query = 
			"update $table_name set
				option_value = replace(
					option_value, '$old_domain', '$new_domain'
				)
				where option_value like '%$old_domain%'";
		if ($wpdb->query($query))
			step($blog->blog_id . ' ') ;
	}
	done();

 ?>