How to change or restore base_url settings with phpMyAdmin

Last modified by chiefair on Wed, December 8, 2010 15:56
Source|Old Revisions  

This is an old revision of the document!


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 side, they should look like the following:
    PATH                         VALUE
    
    web/unsecure/base_url        http://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 side, they should look like the following:
    PATH                        VALUE
    
    web/secure/base_url         https://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 and reindex your URL_rewrite index after changing base_urls.

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