Change domain name

[Patchworks101]

Hi

I currently have a store linked to a domain name. However, after changed in the company, a new domain name has been registered and I need to change the domain link, from the store database to the new domain, to reflect the change in company.

I've gone through the help sections but have not been able to find how to do this. Can anyone help please.

Thanks

[JBW]

You can change it in table ps_shop_url - you might need to re-generate .htaccess after this

[Patchworks101]

32 minutes ago, JBW said:

You can change it in table ps_shop_url - you might need to re-generate .htaccess after this

Hi, I take it that this table is in the SQL database and needs editing within MySQL. I'll have a look thanks

Checked the DB - there is no table ps_shop_url. All the tables start with m8fv_(table name) and none match this 🤔. Was I looking in the correct place ?

Thanks again

Edited April 13, 2021 by Patchworks101 (see edit history)

[JBW]

15 hours ago, Patchworks101 said:

there is no table ps_shop_url. All the tables start with m8fv_(table name)

You might have defined a different prefix m8fv_ instead of ps_. Whats your shop version? In very old versions the urls are stored in prefix_configuration (name PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL) instead of prefix_shop_url

[Patchworks101]

8 hours ago, JBW said:

You might have defined a different prefix m8fv_ instead of ps_. Whats your shop version? In very old versions the urls are stored in prefix_configuration (name PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL) instead of prefix_shop_url

Hi

Found the table thanks. Now to update it and the .htaccess 

Thanks

Bob

[Patchworks101]

22 minutes ago, Patchworks101 said:

Hi

Found the table thanks. Now to update it and the .htaccess 

Thanks

Bob

Oops, somethings not working. I updated the table m8fv_shop_url and .htaccess with the new domain name but now when I open the 'shop' all I get is a blank screen after I've logged in. Pulling hair out now 😕

[yaKay]

Hi,

 

table m8fv_shop_url, column "domain", type the new domain name (e.g. website.com).

In .htaccess find/replace the old website name with the new one.

Are you using new database with the new website? If so, you need to edit also values into /website/app/config/parameters.php

If you face problem because of SSL active/not active, then you need to switch from 0 and 1 from the table m8fv_configuration, values PS_SSL_ENABLED and PS_SSL_ENABLED_EVERYWHERE

 

[inspectaclueso]

https://zemez.io/prestashop/support/how-to/prestashop-1-7-transfer-website-one-domain-another/

[Patchworks101]

13 hours ago, inspectaclueso said:

https://zemez.io/prestashop/support/how-to/prestashop-1-7-transfer-website-one-domain-another/

All was going well until I tried to import the backup and I got the error message (see attached PNG). It only imported 3/4 of the first page of tables into the new DB. I even tried making a compressed file of the SQL but with the same result. I'm now thinking of simply deleting fully the old store and creating a completely new store. A lot more work but it looks like the only way to solve the issue.

[yaKay]

from the screenshot, I see that you are using a new database: 1810953 and not 1719926; at the same time did you give the full rights the user o1810593 on the new db? that user have the privilege to work with the old database (dsb1719926); now you must connect the same user with the new db!

[Patchworks101]

17 hours ago, yaKay said:

from the screenshot, I see that you are using a new database: 1810953 and not 1719926; at the same time did you give the full rights the user o1810593 on the new db? that user have the privilege to work with the old database (dsb1719926); now you must connect the same user with the new db!

Hi

Yes and yes. I am the owner of both and connected wit the same user ID

[yaKay]

1 hour ago, Patchworks101 said:

Hi

Yes and yes. I am the owner of both and connected wit the same user ID

Are in config/settings.inc.php the new db and the new user names?

Did you delete the prod folder (var/cache/prod) ? otherwise u can edit (but it's longer) info related to the  database in var/cache/prod/ContainerXo3vxws/appProdProjectContainer.php 

[Patchworks101]

Problem sorted and thanks to everyone who replied.

My hosting company has a built in tool that changes the domain name and dns automatically. I can now log-into the new shop dashboard and amend all the minor settings  (header images etc etc) for the new store.

Thanks again.