Changed Dynamic Domain Provider

When I got notice of (another) price increase from Dyn.com, I knew it was time to change back to a free provider.  After reviewing a few alternatives, I settled on No-IP.com.  I settled on rklingler.ddns.net as the new domain for this site, and confirmed it was working.

I then quickly (perhaps too quickly) terminated my Dyn.com account, which also disabled the old rklingler.homeip.net address.  And suddenly PressPi was only presenting the most rudimentary information, if it would load at all.  And accessing the administrative page appeared impossible, as it only wanted to look for the rklingler.homeip.net address.

After a few google searches, I determined that I would need to edit the database directly.

mysql -u root -p wordpress

mysql> UPDATE wp_options SET option_value = replace(option_value, 'http://rklingler.homeip.net', 'http://rklingler.ddns.net') WHERE option_name = 'home' OR option_name = 'siteurl';

mysql> UPDATE wp_posts SET guid = replace(guid, 'http://rklingler.homeip.net','http://rklingler.ddns.net');

mysql> UPDATE wp_posts SET post_content = replace(post_content, 'http://rklingler.homeip.net', 'http://rklingler.ddns.net');

mysql> UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://rklingler.homeip.net','http://rklingler.ddns.net');

I needed to make a few more tweaks to make a few pictures come up, but I think I’ve gotten it all fixed.  Not a bad way to start Labor Day weekend.