Just if can be useful for someone, the modifications from Changing the site URL seems to be a bit out of date…
UPDATE wp_site set domain='newdomain.cat' where id=1;
UPDATE wp_options set option_value=REPLACE (option_value,'olddomain.cat','newdomain.cat') where option_name='home';
UPDATE wp_options set option_value=REPLACE (option_value,'olddomain.cat','newdomain.cat') where option_name='siteurl';
UPDATE wp_blogs set domain='newdomain.cat' where domain='olddomain.cat';
UPDATE wp_posts set guid=REPLACE (guid,'olddomain.cat','newdomain.cat');
update wp_sitemeta set meta_value='http://newdomain.cat' where meta_key='siteurl';
With this you can see where is the old domain in wp_options…
SELECT option_name from wp_options where option_value like('%olddpmain.cat%');
And then you can change the different options with:
UPDATE wp_options set option_value=REPLACE (option_value,'olddomain.cat','newdomain.cat') where option_name='xxxx';
And the same for the path (if changed)
select * from wp_options where option_value like ('%/your/old/path%');
And change it with
UPDATE wp_options set option_value=REPLACE (option_value,'/your/old/path','/your/new/path') where option_name='xxx';
If you have a blog network, you’ll have to do this for each blog tables!! (luckily i was trespassing our test site to production, and we only had 2 fixed blogs…)
I also made a search (grep) in the WP directory, themes and plugins, looking for the old path and domain, and changing if some appearance.
For example, i did some changes in (if you have some cache plugin):
wp-content/advanced-cache.php
Hope it helps…
