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');
OTHER ARTICLES YOU MAY LIKE
HOW TO USE SPLIT VIEW IN GOOGLE CHROME
Google Chrome is full of useful features that many people never notice until they appear by accident during everyday browsing. One of those quietly helpful tools is Split View, a feature that makes it much easier to work with two tabs side by side in the same browser window. If you regularly compare documents, read […]
read more
Dynal: The Complete Guide to Effortless Content Creation and Networking
Unlock seamless content creation and effective networking with Dynal’s comprehensive guide, designed to enhance your productivity and online presence.
read more
