Update Site URL in core_config_data after you move to a new server or change domains
This is an old revision of the document!
Created by Brent W Peterson creativedata (at) gmail (dot) com
This is a guide to help you update your URL after you move your site from one environment to another. For example if you have your website on your localhost and now you want to publish it. You will need to change your URL to reflect this.
You will need access you MySQL database and you can use MyPHPAdmin or MySQL workbench. Any tool that can access your database will work. There are quicker ways to find and update your domain in the database, but I will walk you through the safest way we can find.
REMEMBER TO ALWAY BACKUP YOUR DATABASE BEFORE YOU MAKE ANY UPDATES
- select * from core_config_data where path = 'web/unsecure/base_url'
* remember you might have to put in your table prefix if you are using one