If you’ve moved Magento to another directory, setup a staging store, or have completely changed the URL for your store and are unable to access the backend of Magento to update the config, here is how you can change those values:
1. Open up phpMyAdmin, which is usually found in the web-based control panel for your domain.
2. From the sidebar on the left, click on the name of the database that Magento is using.
3. Click on the SQL tab, and in the text area, run the following command:
SELECT * FROM `core_config_data` WHERE `path` LIKE '%base_url%';
4. Click the Check All link and then click on the pencil icon.
5. Update the value fields with the correct URL for your site.
6. Click on the Go button at the very bottom to save your changes.
You should probably delete your cache data as well, so delete the following directories via FTP or SSH:
To do this via SSH, run the following command:
- rm -rf var/cache/ var/session/