How to change base_url settings with phpMyAdmin

DRAJI picture DRAJI · Jun 5, 2013 · Viewed 11.7k times · Source

i have changed base_url in magento back end. Now my website is inaccessible

How to change base_url settings with my phpMyAdmin?

Thanks in advance!

Answer

Renon Stewart picture Renon Stewart · Jun 5, 2013

Take a look @ http://www.magentocommerce.com/wiki/recover/restore_base_url_settings

  1. Open your core_config_data table in phpMyAdmin.

  2. Find the following rows for your unsecure section, they should look like the following:

    PATH                    VALUE
    web/unsecure/base_url   http://www.mydomain.com/
    
  3. Replace http://www.mydomain.com/ with your appropriate domain url (trailing slash necessary) and if you’ve installed in a subfolder append it with a / after it.