Great rename in progress

Posted on by

I’m sure this will end well…

UPDATE wp_options SET option_value = replace(option_value, ‘https://virtuallyfun.com/’, ‘https://virtuallyfun.com/’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wp_posts SET guid = replace(guid, ‘https://virtuallyfun.com/’,’https://virtuallyfun.com/’);
UPDATE wp_posts SET post_content = replace(post_content, ‘https://virtuallyfun.com/’, ‘https://virtuallyfun.com/’);
UPDATE wp_postmeta SET meta_value = replace(meta_value,’https://virtuallyfun.com/’,’https://virtuallyfun.com/’);
UPDATE wp_options SET option_value = replace(option_value, ‘https://virtuallyfun.com/’, ‘https://virtuallyfun.com/’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wp_posts SET guid = replace(guid, ‘https://virtuallyfun.com/’,’https://virtuallyfun.com/’);
UPDATE wp_posts SET post_content = replace(post_content, ‘https://virtuallyfun.com/’, ‘https://virtuallyfun.com/’);
UPDATE wp_postmeta SET meta_value = replace(meta_value,’https://virtuallyfun.com/’,’https://virtuallyfun.com/’);

Since I had purchased virtuallyfun.com quite a while ago, and I had planned on doing this years ago, for some reason today felt like a good day.  I have had mappings in Apache to catch & rename links from a while back, but in reverse.  I have no plans on dumping superglobalmegacorp.com, but you have to admit it is quite long to type in, and the ‘non standard’ name for the blog no doubt wasn’t helping things.  I guess that makes 2017 the year of conformity.

As always, if you can read this, then it’s working.  Old links will continue to function so really nothing going on, same site, same crap, just flipped the aliases.

6 thoughts on “Great rename in progress”

  1. Always happy to learn quick hacks for WordPress… but isn’t the ‘find’ string meant to differ from the ‘replace’ string?
    Much easier URL to remember when in need of some nostalgique as well!
    Whilst switching from http to https, I had to find/replace all of those token as well. Slightly more of a nightmare as not all of the new URLs actually worked.

  2. I also had to use something called blue velvet to run through the database. I have some redirect scheme in Apache setup so that the old domain redirects to the new with the same path, an it has aliases for all the domains so it’ll catch them all.

    The side effect is that I have over 2,300 redirects from the old domain, so now I’m my biggest referer. But I don’t sell advertising, so it really doesn’t matter as I’m the one that gets to look at the numbers and it’s really not that, as I got a bit more aggressive about eliminating bots from the stats.

    It’s all kind of a mess, but it works out OK.

  3. The old host name for the BBS was too long to fit in the phone number field in Telemate (running under DOSBox so ATDT means something), maybe this will help 🙂

  4. I just noticed after posting that that where there used to be a drop down menu in the banner it seems to be broken now – all the links are listed out horizontally instead.

    • Yeah I broke something messing around, and I can’t quite figure out what I did. Those pages are so obsolete….. I may have to re-build the menu and re-create the pages or just delete them all together.

      I was thinking of getting a more flashy theme and dumping the old blog style. I was looking at something more click-bait like, as it works well with images which I have plenty of.

      I’m thinking of shaking some stuff real hard although the underpinning out to be ok. I think.

      Now that I can clear the bots, I only get 400-500 real visitors a day with 3000-5000 page views. Looks like people are more engaged, but I don’t have much reach. I’m sure the long domain+non standard address didn’t help, but after 10 years I’m hoping to be more accomplished. Of course that means writing better…

Leave a Reply