fix wordpress blog url via mysql

Published by exdone

Posted on January 24, 2008

UPDATE wp_options SET option_value=’http://blog.domainname.com’ WHERE option_name=’home’ LIMIT 1;

and the site url

UPDATE wp_options SET option_value=’http://blog.domainname.com’ WHERE option_name=’siteurl’ LIMIT 1;