Transfer Prestashop 1.7 to another domain / subdomain

[Scorpio26]

Hello

 

I'm create a new release with Prestashop 1.7 for my shop previously developed with Prestashop 1.6 

 

I used a subdomain on a server that I use to develop sites.

 

To better explain to you I use alias names.

 

 

 

The new PS 1.7 store is on 

 

www.testsite.com/ps

 

 

So the information that I read in Traffic & SEO SEO & URLs are:

 

 

Store domain: www.testsite.com

SSL domain: www.testsite.com

URI base: /ps/

 

 

I uploaded the site and the DB into the old server www.shopsite.com

 

If i digit the url www.shopsite.com Prestashop goes to www.testsite.com/ps so I can not login into the backstage to make the changes.

 

I found where the domain information are stored in the DB:

 

Table

ps_configuration.PS_SHOP_DOMAIN

ps_configuration.PS_SHOP_DOMAIN_SSL

 

I can not find where the basic URI. 

 

How can I modify this parameter in the database?

 

Thank you

[Scorpio26]

[sOLVED]
I found the table that contains the data I was looking for
this is ps_shop_url

physical_uri - to change the subdomain
domain and domain_ssl - to change the domain

Thank you

[legendstore]

my need was to move main site to sub folder  during tests for 1.7 Prestashop.. such that:

I have www.mywebsite.com 

and  during maintenance I wanted to publish it under  www.mysite.com/maintenance 

1. copy all your  web folder  to /maintenance folder.

under Prestashop SEO/URL's   set:

Store domain: www.mysite.com/maintenance 

 

SSL domain: www.testsite.com/maintenance 

 

URI base: /maintenance 

 

and in order www.mysite.com not to direct to www.mysite.com\maintenance ,

rename htaccess under main folder to different name..

now your www.mysite.com is only accessible under www.mysite.com\maintenance

 

hope that helps

Ayt