magentobase-url

How to change base_url settings with phpMyAdmin

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!

Solution

  • 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.