MySQL problem. Local and hosting site

[NG12]

Hi,

I installed Prestashop locally and I run that with XAMPP.

database host: localhost

folder in XAMPP: htdocs/prestashop

I access locally with this address: "localhost/prestashop" and it works fine.

 

But when I transfer the mysql database in the hosting site and I try to use it in Prestashop it look for "localhost/prestashop" in the address url instead of "www.miosito.com"

 

In the hosting site the configuration is:

database host: localhost

 

If I try to use online created database in XAMPP, then the url "localhost/prestashop" become "www.miosito.com"

 

The original (absolute) path is recorded in mysql database!

How can I fix this to use the database everywhere?

I'd like a "portable" database, not a database that works only in original path!

Thank you

Edited September 11, 2016 by NG12 (see edit history)

[rocky]

That's just the way PrestaShop works. Every time you change your URL, you should go to the Preferences > SEO & URLs tab (or Advanced Parameters > Multistore tab if you're using multistore) and update the domain name, or you can manually edit the ps_shop_url table in your database and change it there.