How to change or restore base_url settings with phpMyAdmin

Last modified by chiefair on Sat, April 30, 2011 09:35
Source|Old Revisions  

How to change or restore base_url settings with phpMyAdmin

Symptom: I changed Base Urls and now my website is inaccessible or I moved everything to a new server, didn't change the base_url and my website is inaccessible.

Instructions are for a simple "one store" website where the "default store view" is set to inherit its setup from the "default config". There will be an additional instance of the below mentioned table rows for each unchecked Use Website checkbox.

1. Open your core_config_data table in phpMyAdmin.

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

PATHVALUE
web/unsecure/base_urlhttp://www.mydomain.com/
web/unsecure/base_link_url{{unsecure_base_url}}
web/unsecure/base_skin_url{{unsecure_base_url}}skin/
web/unsecure/base_media_url{{unsecure_base_url}}media/
web/unsecure/base_js_url{{unsecure_base_url}}js/

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.

4. Find the following rows for your secure section, they should look like the following:

PATHVALUE
web/secure/base_urlhttps://www.mydomain.com/
web/secure/base_link_url{{secure_base_url}}
web/secure/base_skin_url{{secure_base_url}}skin/
web/secure/base_media_url{{secure_base_url}}media/
web/secure/base_js_url{{secure_base_url}}js/

5. Replace https://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. If you haven't received your security certificate and enabled TLS/SSL yet, use http instead of https

6. Clear /var/cache, /var/session after changing base_urls and when you have access to your system reindex your URL_rewrite index. Clearing cache and sessions is necessary because your config is cached and clearing it forces a reread of the configuration data from the core_config_data table and reestablishment of sessions with the proper information.

NOTE: IF YOU HAVE SET YOUR BASE_URL correctly for web/unsecure/base_url and web/secure/base_url YOU DO NOT HAVE TO MESS AROUND WITH CHANGING THE {{UNSECURE_BASE_URL}} and {{SECURE_BASE_URL}} MACROS in the rest of the entries.




 

Magento 2 GitHub Repository

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs