Import Website to local

[kingone]

Hello,

My actual website is on the server.

So I export it with DB.

 

I would like to import it locally.

So I install Xampp for mac.

On settings.inc.php I put right credentials.

 

I would like what other change should I make?

 

I put on DB for ps_configuration in PS_SHOP_DOMAIN: localhost/websitename

For the back-end he doesn't load CSS.

On front-end I have this error: server DNS address could not be found, ERR_NAME_NOT_RESOLVED

Thank you in advance for your help.

[NemoPS]

Prestashop version?
You should change it in ps_shop_url as well

[kingone]

Hello,

 

I use 1.6.1.5

I put localhost/myname on PS_SHOP_DOMAIN, PS_SHOP_DOMAIN_SSL, and also here ps_shop_url on domain and domain_SSL. 

[mono1]

Hello.. any luck with this? Did you solve the problem? I am experiencing exactly the same...

backoffice with no css

frontoffice server DNS address could not be found./ERR_NAME_NOT_RESOLVED

ps 1.6.1.1

Maybe this is due to incompatibility issues..  i.e. on my live linux server there is mysql while locally on my linux xampp there is the latest mariadb.. The thing is that I don't know how to replace mariadb with mysql... Take into account that the db is not small, its 110MB successfully(?... that's what the report says anyway) imported with bigdump.. I fresh installed this XAMPP and manually installed a wordpress installation just to check. Wordpress works well and appears at localhost/xy**wordpress. Phpmyadmin also works well. The thing that does not work well is my prestashop backup.. Very very frustrating..

UPDATE

In the past I have migrated prestashop installations from live to localhost and vice-versa countless times (literally). Until now it was straight forward.. All I had to do is a backup-restore of database, change ps_shop_url  and the alterations at settings.inc.php.. not this time.... no..

 Suggestion1. Have a backup of your website

Suggestion2. Never get tired of cleaning cache from your website and from your browser

 

So.. today I finally managed to get rid of xampp and mariadb in order to install lampp with latest mysql. (Thanks to this good tutorial and following the tips of nnov at the comments; but this has much to do with linux localhost environment)

After attempting to import my db from phpmyadmin and using bigdump I failed once again. Then I successfully imported from local mysql server by following this usefull post.

However still nothing...couldn't make it work. When in backoffice there was no css. I turned errors on from defined.inc.php and when attempted to access my frontpage I got error 400 with no css again.

The following are the correct database settings that you should have for your website to work at localhost.

You have to open the table ps_shop_url and there you enter:

domain: localhost

domain_ssl:localhost

physical uri:/your-local-website-folder/

additionally you have to go at table ps_configuration and alter the values at row PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL from www.yourlivedomain.xyz to localhost

Then login to your back-office.

Probably you should have normal css at your backoffice.

Try to access front-office. If everything is ok..cool. In my case wasn't. I was getting 404 error.

Delete .htaccess of website from the route folder of your website. From Performance Clean cache. Additionally disable cache.

From SEO & URL's disable friendly URL and try to access frontoffice. In my case that worked. Then I switched back to friendly URL's only to notice, after the third time of doing so, that below of this switch I was getting with light grey letters an error message. The message was that I had not enabled on my apache server mod_rewrite.

The answer to this final problem was to enable mod_rewrite following this very good tutorial.

Now everything is ok, I have my website at my localhost ready to experiment with any changes that I would like, but most importantly I know that my website is in good state... All these thanks to all the good people that helped me with their very nice tutorials... I don't really enjoy it but everyday you have to learn something new I guess...lol

I will be really happy if you can find this usefull and avoid all this headache I got until I find this solution

 

 

Edited November 22, 2017 by mono1 (see edit history)