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

web/unsecure/base_url

web/secure/base_url

web/cookie/cookie_domain

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 www.old-site-url.com and  www.new-site-url.com with your website URLs

 

Thank you for reading,

 

The following two tabs change content below.

Arshad M

Magento Certified Developer at Codilar
Passionate full stack eCommerce web developer, Magento Certified Developer.

Latest posts by Arshad M (see all)

Leave a Reply

Your email address will not be published. Required fields are marked *