WordPress problem when moving folders
February 26, 2012 / by Marco / Categories : Technology
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:
UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'http://olddomain.com','http://newdomain.com'); UPDATE wp_posts SET post_content = replace(post_content, 'http://olddomain.com', 'http://newdomain.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com');
DO YOU LIKE WHAT YOU'VE READ?
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!
OTHER ARTICLES YOU MAY LIKE

VidTechy: The Ultimate Tool for AI-Powered Video Optimization
Unlock the potential of your videos with VidTechy, the ultimate AI-powered tool for seamless video optimization and enhanced viewer engagement.
read more
HOW TO STREAMLINE YOUR BUSINESS WITH PUSH LAP GROWTH AND SUBSCRIBR
Streamline your business operations with Push Lap Growth and Subscribr, enhancing efficiency and customer engagement through innovative subscription models.
read more