Skip to content

Instantly share code, notes, and snippets.

@manojiksula

manojiksula/magento_database_move.sql

Forked from eristoddle/magento_database_move.sql
Created March 3, 2016 07:31
Show Gist options
  • Save manojiksula/0b2c033479f74b5cbfe9 to your computer and use it in GitHub Desktop.
Save manojiksula/0b2c033479f74b5cbfe9 to your computer and use it in GitHub Desktop.
Download ZIP
Database Queries for moving a Magento database from insecure local to secure host.
Raw
magento_database_move.sql
UPDATE `magento`.`core_config_data` SET `value` = 'http://yoursite.com' WHERE `core_config_data`.`path` ='web/unsecure/base_url';
UPDATE `magento`.`core_config_data` SET `value` = 'https://yoursite.com' WHERE `core_config_data`.`path` ='web/secure/base_url';
UPDATE `magento`.`core_config_data` SET `value` = 1 WHERE `core_config_data`.`path` ='web/secure/use_in_frontend';
UPDATE `magento`.`core_config_data` SET `value` = 1 WHERE `core_config_data`.`path` ='web/secure/use_in_adminhtml';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment