Skip to content

Instantly share code, notes, and snippets.

@nikolazic

nikolazic/get_magento_urls.sql

Last active December 29, 2015 03:09
Show Gist options
  • Save nikolazic/7605305 to your computer and use it in GitHub Desktop.
Save nikolazic/7605305 to your computer and use it in GitHub Desktop.
Download ZIP
Get Magento URLs
Raw
get_magento_urls.sql
# Find out what the old URL is
select * from core_config_data where path like 'web/%secure/base_%' or path = 'admin/url/custom' order by path;
# Replace
update core_config_data set value = replace(value, '://OLD', '://NEW') where path like '%web/%secure/base_url%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment