[solved] Migrating online site back to localhost

[kerikhaos]

Hi everyone,

first a big "hello" from me, my name is keri and im new to this forum and only just started playing around with prestashop and find it an amazing product.

I have a big problem however and hope its something easy enough for advanced users here to help me out. I made the mistake of deleting my localhost prestashop archive (the test site before i moved online). Now what i have done to try get this site back was ftp the online directory back to my localserver and tried to get it running as it was before. Im having no luck so far and ive been trying for days with this problem.


my website is www.eniac.com.cy and its only been a while. The problem is my xampp installation is having difficulty running the system as it is from the ftp download.

Of course i have gone into config and replaced the details of the sql server and domain locations etc with all username and passwords and all im able to load is my index.php without any graphics or formatting. It just loads text it seems. Not to mention when i click on a hyperlink the link takes me to the next page which is pointing to the online website (not the localhost files)

My procedure was this......

1- downloaded the website via ftp
2- installed xampp and configured mysql
3- loaded up the latest sql backup downloaded from the online prestashop
4- placed my website directory into the htdocs folder
5- configured my settings.inc file to point to the correct database server etc etc
6- attempt to load my site and it brings up my homepage with no graphics and no formatting

i will try to attach a picture so you can see if it makes my problem clearer

thanks for any help in advance

[kerikhaos]

I fear that once the site has gone live and the original test site has been lost i wont be able to create an offline local test version of the site......

 

again a big thanks in advance for anyone who can help me out or point me in the right direction

[SmartDataSoft]

Here is what need to transfer localhost site to live site.

1.export database.

then zip full site

 

2. upload full site and then unzip

then import the database

after that you need to change the ps_shop_url and set your site url and also need to put the folder name.

and done.

 

i debug your site and saw this http://apolyviou.com/themes/sports-purple/cache/0c6c4a4aa926d9f5b1018ae4534bc4da_all.css'>http://apolyviou.com/themes/sports-purple/cache/0c6c4a4aa926d9f5b1018ae4534bc4da_all.css

 

this means that you didn't change the folder name so it try to got the main root folder

 

http://apolyviou.com/eniactest.com/themes/sports-purple/cache/0c6c4a4aa926d9f5b1018ae4534bc4da_all.css

 

The first file do not find css and my modified file got the css. So please go to ps_shop_url and change your shop domain folder. and it will work

[kerikhaos]

thanks very much for helping hand......i will go and try what you said and report back my results

 

But from reading your reply i dont think you understand fully what i want to do. I want to convert my live site (which is working ok currently) into a local site for testing. How will i manage to get xampp to load the site properly from local instead of the live?

 

again thank you very much for the help

Edited June 28, 2013 by kerikhaos (see edit history)

[SmartDataSoft]

Oh, i think that your site is running to localhost and you want to live that.

No problem you have to do the work which i told your just reverse that.

Import database and and then change your

ps_shop_url 

domain as

 localhost

and then put the folder name if your site is not

root localhost

After that go to

settings.inc.php and edite your database name user name and password

define('_DB_NAME_', 'prestashop_1.5.4.1');
define('_DB_USER_', 'root');
define('_DB_PASSWD_', 'root');

after that visit your site , and it will sove your problem .

Edited June 28, 2013 by smartdatasoft (see edit history)

[kerikhaos]

thanks very much for all the help, as soon as i try what you said i will let you know how i got on.

 

thanks very much again

[kerikhaos]

ok ive tried to do what you said....

 

i have changed settings and edited the sql file so that everything which had http://eniac.com.cy was converted to http://localhost/eniac

 

i cant find ps_shop_url anywhere. Not in the settings file or the sql backup file. Where do i chage this? in the admin login of prestashop? i mean the backend of the prestashop?

 

im getting the website load up as the picture in my first post (no graphics and just fonts and texts)

 

i try to load

 

http://locahost/eniac/index.php

 

 

thanks for any additional help

[JoeyPanda]

Great topic I have the same type of situation except I didn't have a offline version first.

[bessongboutique]

i did all step but i lost my css. my themes doesn't look as those on line

thanks for help

[El Patron]

changing your shops URI for localhost

 

This is the folder name that runs in your xamp.

 

for 1.4 you change this in the settings.inc.php

 

for 1.5 you MUST change URI back office-->preferences-->seo & urls (change the URI to your folder name)

if you do not have access to back office, then you can change the uri(s) for your shop(s) using phpmyadmin, table yourprefix_shops

[musel73]

Hi,

 

great topic, I learned much, but still have a problem :

 

• I setup XAMPP
• I copied the files from FTP into htdocs\viweiPrestashop1_5_6
• I copied the complete database and changed the settings.inc.php
• I change with phpadmin ps_shop_url : domain = localhost   --- domain_ssl = localhost --- phyislcal_uri = /viweiPrestashop1_5_6/
• When calling my page by http://localhost/viweiPrestashop1_5_6, all images are missing and all links will end to http://localhost/xampp/

Where is my mistake?

 

Thanks!

 

Michael

[El Patron]

try this:

 

from back office turn friendly url (off or on) and  save.  Then set friendly url back to (off or on).  This will regnerate your .htaccess file.  then make  sure to clear your browser cache and retest.

 

 

Hi,

 

great topic, I learned much, but still have a problem :

 

• I setup XAMPP
• I copied the files from FTP into htdocs\viweiPrestashop1_5_6
• I copied the complete database and changed the settings.inc.php
• I change with phpadmin ps_shop_url : domain = localhost   --- domain_ssl = localhost --- phyislcal_uri = /viweiPrestashop1_5_6/
• When calling my page by http://localhost/viweiPrestashop1_5_6, all images are missing and all links will end to http://localhost/xampp/

Where is my mistake?

 

Thanks!

 

Michael

[emvoo]

http://www.prestashop.com/forums/topic/299575-solvedmove-from-server-to-localhost/

[musel73]

Hello El Patron,

 

your hint was great, now it works. Thanks a lot.

 

Best regards

 

Michael