Crucial Hosting

Updating The Magento Base URLs

If you're unable to access the backend of Magento to update the unsecure and secure URLs for your store, here's how to do it with phpMyAdmin.

  • Applies To: All Services
  • Difficulty: Easy
  • Software Required: Magento
AWS
This article was last updated on November 4th, 2015

If you've moved Magento to another directory, setup a staging store, or have completely changed the URL for your store (and are being redirected to the old URL or 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 you can find in your cPanel.
  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%';
  1. Click the Check All link and then click on the pencil icon.
  2. Update the value fields with the correct URL for your site.
  3. 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 directory via FTP or SSH:

var/cache/

To do this via SSH, run the following command:

rm -rf var/cache/

Professional hosting platform starting at $10/mo

View Plans