reset wordpress site & home urls

When undergoing a large updates to your WordPress site, if like me you are thinking about undergoing a radical theme update,  and you’re unsure what impact your new them will have on all your existing plugins and layout of your existing blog posts. You may want to create a development version of your website on a test server.

Moving a WordPress website, is a fairly simple task, but there are a few sneaky gotcha’s that can throw you during the process.  One of these gotchas, if you’re not familiar with it is the reset of your WordPress site and home url’s.

The options are stored within the database and will require you to update them there.  You can easily do this by accessing your server via SSH and logging into mySQL.

ssh username@127.0.0,1
mysql -u username -p  databaseName

You can then retrieve the Id’s of the two fields in question, by executing a simple select statement.

SELECT * FROM wp_options WHERE option_name = 'siteurl' OR option_name = 'home';

This query will return the rows providing the ID and Values the application has been set to.  We now need to update these values to whatever the new value you require  i.e. New Server IP Address or Domain name.

UPDATE wp_options SET option_value = '' WHERE option_name = 'home' OR option_name = 'siteurl';

This will reset the app, and you will now be able to browse to the application on URL you have set it too.

Gary Woodfine

Technical Director at Denizon
Gary is Technical Director at Denizon, an independent software vendor specialising in IoT, Field Service and associated managed services,enabling customers to be efficient, productive, secure and scalable in a way which helps them address and reduce their ecological impact.

Denizon's product line successfully integrate IoT, Artificial Intelligence and Blockchain technology to enable efficient, productive, secure and scalable solutions to help organisations address increasing energy demands, ecological impact and Health & Safety concerns of their staff.

Latest posts by Gary Woodfine (see all)