Posted By

jaspertandy on 02/13/09



Versions (?)

WordPress blog changes domain

 / Published in: MySQL


This gets me every time. Why doesn't my blog work?! Oh yeah, that's why.

  1. UPDATE wp_options SET option_value = "http://domain.tld" WHERE option_name = "siteurl" OR option_name = "home";

Report this snippet  


RSS Icon Subscribe to comments
Posted By: troynt on February 13, 2009

Yes, this is a gotcha.

May want to add queries for wp_posts table replacements, for fixing images, and links.

Posted By: jaspertandy on February 18, 2009

Yeah, that's not a bad idea - shame there's no regex replace functionality, otherwise it could remain in MySQL.

You need to login to post a comment.