We come across this from time to time and it’s a common issue when a client changes their domain name due to a rebrand or upgrade from .co.uk to .com

When we changed a Base Url Change Magento 2 there are several sets to take but as always please take this as a guide and backup, backup and backup before modifying your Database.

So, let’s dive straight and take an example that our client is changing from a .co.uk to a .com. example www.domain.co.uk to www.domain.com

 

Lets Go.

Log in to your server via SSH (we are using a terminal on a mac)

Connect to your Database – this can be controlled like this:

mysql -u root -p 

Enter password when asked.

Then we need to update baseurl in core_config_data:

UPDATE core_config_data
> SET value = 'http://www.yourdomain2.com/'
> WHERE path IN ('web/secure/base_url', 'web/unsecure/base_url')

Next Step

UPDATE core_config_data
> SET value = REPLACE(value, 'http://www.domain.co.uk/', 'http://www.domain.com/')
>WHERE path = 'design/head/includes';

If this throws up an error use following: This happened to us on the MariaDB cloud server

Change the web/unsecure/base_link_url also:

UPDATE core_config_data
> SET value = 'http://www.yourdomain2.com/'
> WHERE path IN ('web/unsecure/base_link_url');

 

Then changed Store Url

php bin/magento setup:store-config:set --base-url="http://www.domain.com/"

php bin/magento setup:store-config:set --base-url-secure="https://www.domain.com/"

Finally to finish clearthe cache:

php bin/magento cache:flush