Multi site nightmare headache WordPress

Dan | gteh answers:

Run this query in phpmyadmin under the SQL tab. There are 2 spots you need to update in the wp_options table

UPDATE wp_options SET option_value = replace(option_value, 'http://old.site.url.com', 'http://new.site.url.com') WHERE option_name = 'home' OR option_name = 'siteurl';


then check your .htaccess file and make sure the rewritebase and rewrite rules match the new locations.

idt answers:

Here are the tables you may need to check and change value to your new domain:
wp_options - site_url and home
wp_blogs - domain
wp_site - domain and path
wp_sitemeta - site_url
You also need to update each of the wp_*_options (e.g. wp_1_ , wp_2_, wp_3_) table and adjust the fields site_url and home

Then this:
UPDATE wp_posts SET guid = REPLACE (guid, 'http://oldsiteurl.com', 'http://newsiteurl.com');
UPDATE wp_posts SET post_content= REPLACE (post_content, 'http://oldsiteurl.com', 'http://newsiteurl.com');

---

Francisco Javier Carazo Gil answers:

You should also change data that is serialized and you cannot change using UPDATE SQL. This tool you provide this functionality: [[LINK href="http://interconnectit.com/124/search-and-replace-for-wordpress-databases/"]]http://interconnectit.com/124/search-and-replace-for-wordpress-databases/[[/LINK]]

It's easy to install and use and it is really functional.

---