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
UPDATE core_config_data SET value = REPLACE (value,'http://www.old-site-url.com/','http://www.new-site-url.com');
Replace www.old-site-url.com and www.new-site-url.com with your website URLs
Thank you for reading,