Magento core_config_data replace all old URL with new URL

Here is the small MySql code snippet to replace all the occurrence of OLD site URL with new URL, after the success full migration

Magento will store your store URLs in core_config_data table, after migrating your site to new server or domain, or if you want to change the site URLs, it’s really very headache to change the old URLs to new URLs, especially if you are on a Cloud server.

Because you need to change your URL for multiple paths including




Also you may be need to check other rows.

To get out of this USE the bellow code snippet to replace all the existence of the OLD URL with your NEW URL

Replace and with your website URLs


Thank you for reading,