We recently changed Chrissy’s shop’s domain name, and it wreaked ravok on their website’s WordPress installation. I pointed the domain to the right path on the web server, but the blog’s settings were wrong in the MySQL database. (All the dynamic links were pointing to the old domain name, including the links to the admin interface.) After some futzing around, I found the necessary tables, columns, and values that needed changing. If you ever change a domain name out from under your WordPress installation, make the following changes to the WordPress DB…<\/p>\n
In the MySQL CLI:<\/p>\n
update wp_options set option_value=”YOUR BLOG URL HERE” where option_name=”siteurl”;<\/p>\n
update wp_options set option_value=”YOUR BLOG URL HERE” where option_name=”home”;<\/p>\n","protected":false},"excerpt":{"rendered":"
We recently changed Chrissy’s shop’s domain name, and it wreaked ravok on their website’s WordPress installation. I pointed the domain to the right path on the web server, but the blog’s settings were wrong in …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[],"class_list":["post-190","post","type-post","status-publish","format-standard","hentry","category-computers"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p32FB4-34","jetpack-related-posts":[{"id":132,"url":"https:\/\/www.pressleypress.com\/blog\/?p=132","url_meta":{"origin":190,"position":0},"title":"Bad Domain Names – Oldie but a Goodie","author":"Matt","date":"February 29, 2008","format":false,"excerpt":"I'll take \"The Rapist\" for $100 Alex! The category is \"Therapist\" Mr Connery. Along the same lines, here's some real domain names that can be misread... 1. Who Represents is where you can find the name of the agent that represents any celebrity. Their Web site is www.whorepresents.com\/ 2. Experts\u2026","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1097,"url":"https:\/\/www.pressleypress.com\/blog\/?p=1097","url_meta":{"origin":190,"position":1},"title":"Amazon EC2 is the coolest","author":"Matt","date":"January 20, 2014","format":false,"excerpt":"I'm really digging all the functionality that Amazon EC2\u00a0offers. This blog isn't hosted there, but I've been working on a virtual server there for storing and serving my images. So far, so good. Ubuntu 12.04 + Gallery + MYSQL FTW.","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":801,"url":"https:\/\/www.pressleypress.com\/blog\/?p=801","url_meta":{"origin":190,"position":2},"title":"Mountain Lion installation on home built Fusion Drive","author":"Matt","date":"November 5, 2012","format":false,"excerpt":"MacOSXHints.comvia Mountain Lion installation on home built Fusion Drive.","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1280,"url":"https:\/\/www.pressleypress.com\/blog\/?p=1280","url_meta":{"origin":190,"position":3},"title":"Saitek X52 Pro Not Being Detected by Driver Installation Program (Windows 8 and 10)","author":"Matt","date":"March 11, 2016","format":false,"excerpt":"My X-52 has been a real pain in the butt in Windows 10. It's hit or miss if after a reboot the joystick is going to be detected by Windows. Attempting to re-run the driver installer doesn't help. I found the following tip at\u00a0the Windows Support site\u00a0and seems to do\u2026","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":49,"url":"https:\/\/www.pressleypress.com\/blog\/?p=49","url_meta":{"origin":190,"position":4},"title":"Apple MacBook SMC 1.1 Update – So Far, So Good","author":"Matt","date":"November 1, 2006","format":false,"excerpt":"As I've posted here before, my MacBook has been experiencing the Random Shutdown problem that many MacBook owners have reported. My MacBook has had it's logic board replaced, and about 2 weeks ago, the random shutdowns began happening again. Apple recently released v1.1 of their SMC update, and they state\u2026","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":277,"url":"https:\/\/www.pressleypress.com\/blog\/?p=277","url_meta":{"origin":190,"position":5},"title":"Nintendo “Fixes” the Wii’s Storage Issue with System Update 4.0","author":"Matt","date":"March 26, 2009","format":false,"excerpt":"Nintendo just released System Update 4.0 for the Wii, which adds a new channel called the \"SD Card Channel.\" With this update, you can now run games directly off your SD card instead of having to reinstall the game from the card, to the Wii. The update also adds support\u2026","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=190"}],"version-history":[{"count":0,"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/190\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pressleypress.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}