WordPress Basics

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.

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

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.

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

Freelance Full Stack Developer at threenine.co.uk
Helps businesses by improving their technical proficiencies and eliminating waste from the software development pipelines.

A unique background as business owner, marketing, software development and business development ensures that he can offer the optimum business consultancy services across a wide spectrum of business challenges.

Latest posts by Gary Woodfine (see all)

Affiliate Disclaimer

Disclosure: Please note that some of the links included in the blog posts are affiliate links, which means I will earn a commission if you decide to make a purchase.

I only include affiliate links to products, services and companies that I have personal experience and have actually used. I only recommend them because they are helpful and useful, not because of the small commissions I make if you decide to buy something.

Please do not spend any money on these products unless you feel they are relevant, suitable and will help you achieve your goals.

Buying anyone of these products and the commisions earned will not make me an overnite multi millionaire, but they will help to cover the hosting costs and compensate for the countless hours and effort I put in to create meaningful and valuable free content I provide to help others succeed.

You've also undoubtedly noticed that I also use various advertising networks - unless of of course you're using an Ad blocker, this is also an attempt to reduce my monthly deficit I experience in providing free relevant, valuable and on occassion insightful content for the benefit of others.

I only really make some money if people click on the ads, unless of course you consider 1c per 1000 impressions real money!

Bear in mind just how many impressions I need to make before I can cover my £20 hosting costs a month!

If you are using an adblocker and guilt stricken you can of course donate using any of the buttons below, but I won't be holding my breath.

Buy me a coffeeBuy me a coffee

π