<\/p>\n

I tried moving my WordPress folder to the root of my hosting account and things went pear shaped. After some debugging, I noticed that in the database stored the URL of the website. This meant I had to change most of the data entries in the database. I knew nothing about SQL queries but after some research I managed to find some code that was able to change my domain URL and here it is:<\/p>\n

\n

UPDATE wp_options SET option_value = replace(option_value, 'http:\/\/olddomain.com', 'http:\/\/newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';\r\n\r\nUPDATE wp_posts SET guid = replace(guid, 'http:\/\/olddomain.com','http:\/\/newdomain.com');\r\n\r\nUPDATE wp_posts SET post_content = replace(post_content, 'http:\/\/olddomain.com', 'http:\/\/newdomain.com');\r\n\r\nUPDATE wp_postmeta SET meta_value = replace(meta_value, 'http:\/\/olddomain.com', 'http:\/\/newdomain.com');<\/code><\/pre>\n<\/blockquote>\n
DO YOU LIKE WHAT YOU'VE READ?<\/div>
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!\r\n\r\n
\n
\n\n
Name<\/label>\n<\/div>\n
Email<\/label>\n<\/div>\n
\n<\/div>\n<\/form>\n<\/div>\n<\/p>\r\n\r\n<\/div><\/div>\n
<\/div>","protected":false},"excerpt":{"rendered":"
  I tried moving my WordPress folder to the root of my hosting account and things went pear shaped. After some debugging, I noticed that in the database stored the URL of the website. This meant I had to change most of the data entries in the database. I knew nothing about SQL queries but […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[498,495,502,503,493,225,403,500,486,487,496,494,277,485,501,499,490,1936,488],"class_list":["post-333","post","type-post","status-publish","format-standard","hentry","category-technology","tag-data-entries","tag-debugging","tag-domain","tag-domain-url","tag-folders","tag-home","tag-meta","tag-name","tag-option-name","tag-option-value","tag-pear","tag-root","tag-set","tag-siteurl","tag-sql-queries","tag-update","tag-where","tag-wordpress","tag-wp"],"_links":{"self":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/comments?post=333"}],"version-history":[{"count":1,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/333\/revisions"}],"predecessor-version":[{"id":334,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/333\/revisions\/334"}],"wp:attachment":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media?parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/categories?post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/tags?post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}