[SOLVED] Replicating Prestashop From My Online Site To Run on My Local PC

[deepee]

Hi

I would like to run an exact copy of my Prestashop on my local machine.

I have been experimenting with XAMPP and for a new installation, it works great.

I then deleted my new installation and database and downloaded backups of my Prestashop folder and put it in htdocs.

I downloaded a backup of my database and used phpMyAdmin to create a new database with the same details as my real one. The tables were successfully recreated from the backup.

However Prestashop will not start, with error: "Link to database cannot be established."

I have had a look at some of the Prestashop configuration files but cannot find where I can change the path to the database.

Can anyone please help me?

Thanks
Deepee

[Patric]

You'll find it in the /config/settings.inc.php file.

[deepee]

Hi Patrick

Thanks, I found the settings and after a little trial and error, it works perfectly.

I initially had a problem seeing some of the products I had added but rebuilt the database again and all was good.

Thanks again
Deepee

[devtrend]

I posted a version of this in a separate thread but I think it's worth repeating here for anyone like myself who might encounter a list of issues trying to create a local replica.

I first tried (without success) to replicate on my local pc with wamp running alongside iis. I suspect that a more savvy person could succeed but I wasn't able to.

Then I tried to replicate on my ubuntu installation running under vmware. After several trials and errors I was able to succeed as I describe below.

"It has been somewhat of an odyssey for me to try to replicate my prestahop from my webhost to my localhost. The key points for me to achieve success were:

0. install lamp on the local pc
1. then create a mysql database with the same name and passwd as the one on the webhost
2. do a fresh installation of prestashop in the local environment
3. copy config/settings.inc.php to a safe spot
4. over-write the fresh installation of prestashop with your downloaded copy from the webhost
5. Overwrite the settings config/settings.inc.php fwith the copy from the fresh install
6. use phpmyadmin to import the dowloaded copy from the webhost (be mindful of memory_limit problems and replicated entries problems, which I experienced)
Hopefullly this should end up with a success local clone."

The problems and workarounds referred to in step 6 are described in http://www.prestashop.com/forums/viewthread/33726/help_installation___upgrade/what_version_am_i_using/

Cheers,
Dev.

[amoon]

I posted a version of this in a separate thread but I think it's worth repeating here for anyone like myself who might encounter a list of issues trying to create a local replica.

I first tried (without success) to replicate on my local pc with wamp running alongside iis. I suspect that a more savvy person could succeed but I wasn't able to.

Then I tried to replicate on my ubuntu installation running under vmware. After several trials and errors I was able to succeed as I describe below.

"It has been somewhat of an odyssey for me to try to replicate my prestahop from my webhost to my localhost. The key points for me to achieve success were:

0. install lamp on the local pc
1. then create a mysql database with the same name and passwd as the one on the webhost
2. do a fresh installation of prestashop in the local environment
3. copy config/settings.inc.php to a safe spot
4. over-write the fresh installation of prestashop with your downloaded copy from the webhost
5. Overwrite the settings config/settings.inc.php fwith the copy from the fresh install
6. use phpmyadmin to import the dowloaded copy from the webhost (be mindful of memory_limit problems and replicated entries problems, which I experienced)
Hopefullly this should end up with a success local clone."

The problems and workarounds referred to in step 6 are described in http://www.prestashop.com/forums/viewthread/33726/help_installation___upgrade/what_version_am_i_using/

Cheers,
Dev.

This information is very useful. Thanks to the poster and the helpers!

[PrestaOZ]

Thank you a million times amoon.

I have been developing a site on a live server and have been stressing I would lose it.

With your help, I now have a fully functional local copy on my laptop.

Cheers mate.

Ian

[switchex]

hello, i need to do a similar thing! except that my current prestahop is not hosted, it is just on my PC and i would like to make a backup of it (just incase i lose my files or something happens to my pc or if i want to take my work to a different computer at any time) ..
i have asked the same question several times before, here in the forum, but i don't think i ever got an answer .. so do u guys know how i can make a backup of my prestashop which is currently on my local pc?

thanks.