Zen Cart Logo
Forums / General Questions / Open a backup copy on LocalHost

Open a backup copy on LocalHost

Views: 4,397

Results 21 to 40 of 50
3 Jan 2012, 3:57 AM
#21
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Open a backup copy on LocalHost

Serious:

Gonna bite the bullet and and start over with fresh build using ZC 1.5.
Since an upgrade is essentially a rebuild anyway, using the latest version is not a bad idea.
The benefit of following the documented upgrade instructions is that it coaches you thru the process of finding all your customizations so you can more quickly recreate any required changes on the new site ... basically an intelligent checklist of sorts.

3 Jan 2012, 12:03 PM
#22
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,872
Plugin Contributions:
7

Re: Open a backup copy on LocalHost

Modify the two local\configure.php files to reference your localhost installation, physical filepaths and local database name.THIS is a useful tip, I can't find it documented anywhere...?
Should be in the WIKI.

3 Jan 2012, 1:37 PM
#23
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

DrByte:

No. EVERYTHING gets left behind, except whatever files under public_html belong to your Zen Cart piece.

public_html is where your live website content exists. If your Zen Cart files are directly in public_html then you'll pay attention to what's in public_html. If your Zen Cart files are in a subdirectory under public_html, then it's that subdirectory to focus on. Anything else is entirely outside the scope of Zen Cart, and you'll need to assess those yourself.Okay, got it. thanks.

Step 6 in the wiki says to "Grab the "Fix_Cache_Key" utility...

Ummmm....okay? Where exactly is it?

3 Jan 2012, 1:57 PM
#24
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

Found it, ran it.
So now I've got a functional copy of ZC loaded on my PC.
It doesn't look like my live site though.
I'll go play around and see if I can figure out why.

3 Jan 2012, 3:18 PM
#25
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

in Blue..

  1. Go back to phpMyAdmin on your NEW server.
    a. Select your NEW database (that you installed the NEW Zen Cart into)okay...Done
    b. DROP all the tables. (Check them all and scroll down and on "With Selected..." select DROP. Confirm Yes. okay...Done
    c. Click on the SQL tab across the top (or "Import" on newer phpMyAdmin configurations) and click Browse. Huh? I see no BROWSE BUTTON
    d. Select the SQL file you made in step 3a when you exported your old database, and click Go.

When i try yo go to the local store I get the following:
1146 Table 'seriouso_zc1.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

3 Jan 2012, 5:55 PM
#26
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Open a backup copy on LocalHost

Step 2b .. you said "Done". But, it looks like you didn't actually use the same DB_PREFIX on the new store as you did on the old store.
Or, your configure.php is pointing to a database named "seriouso_zc1" which doesn't exist on your localhost.

3 Jan 2012, 7:46 PM
#27
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

oh Snap! It took me a few minutes but I finally found the problem.

I entered a - instead of a _ for the in the DB prefix name. Gotta lean on the ShIfT key a litte harder next time....d'Oh!!:censored:

Thanks for all the help folks!

Now I can start trying out mods/add-on's locally instead of blowing up my live site.

Now what did I do with that Fast and Easy Checkout zip file......

12 Feb 2012, 6:05 PM
#28
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

So after trying to install the fast and easy checkout mod I had a complete mess on my hands. I've started fresh (again) and have reinstalled ZC1.39 and downloaded a back copy of my site.

I'm little clear (still) on which files I need to copy from my back up copy to the Local site I just installed. Is it simply a matter of cutting and pasting the public_html folder?

Last time around I copied darn near everything from the back-up, but that goes against what's been stated in this thread already.

12 Feb 2012, 9:02 PM
#29
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

Make that "I'm a little UN-clear.....

13 Feb 2012, 3:45 AM
#30
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

Well I've tried many variations and still can't get a local version of my live site to come up on my local store.

HELP!!

13 Feb 2012, 1:23 PM
#32
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

Same as what's in the wiki and setting up a fresh copy of ZC isn't the issue. I've got that covered.

I'm struggling with which of my files (from the live site) go where on the local site.

Spent all day yesterday trying to figure it out. No matter what I tried I simply couldn't get the local site to look like the live site. Categories, images, format, etc. I was able to switch from the standard template to the template that i use on my live site, but that's it.

13 Feb 2012, 6:39 PM
#33
picandnix avatar

picandnix

Totally Zenned

Join Date:
Dec 2010
Location:
UK
Posts:
1,780
Plugin Contributions:
2

Re: Open a backup copy on LocalHost

Did you get the live DB into your local build? Sounds like your local version is using the DB that you most likely created when you installed XAMMP. Have a look in XAMMP phpmyadmin, how many databases do you have? Does the DB name math that of the details in your 2 configure files?
Posted via Mobile Device

13 Feb 2012, 8:33 PM
#34
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

I downloaded the DB from my live site and followed the instructions in the wiki.

i start getting error messages afte copying the file from my back-up copy of my live site over the new ZC install on my PC.

I've tried this about a dozen times.

I can get the new ZC (1.39) installed and running without any isues at all.

I've dropped the DB files and imported per the wiki without any problems.

This is what I'm getting when I try to get to the store (localhost/zencart):

1146 Table 'seriouso_zc1.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

When I try to get to the Admin page I get a 404 error.

13 Feb 2012, 8:53 PM
#35
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Open a backup copy on LocalHost

You're going around in circles and skipping steps. If you'd follow the instructions in the article I pointed you to, you'd have no problems.

Your latest error about "1146 Table 'seriouso_zc1.configuration' doesn't exist" is a result of you using different DB_PREFIX settings in your localhost vs your backup. That's addressed in Step 2-a of the tutorial I pointed you to.

13 Feb 2012, 8:59 PM
#36
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

I swear on my mothers grave that I've done the steps exactly as listed in the wiki....and she's not even dead yet!!:lookaroun

I'll try again this evening.

15 Feb 2012, 3:08 AM
#37
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

Well I've made some progress.

Started from scratch including reloading XAMPP.

So now I've got a functional copy of my live site but the no Admin Screen....nothing but a white page. No fields for name/password.

Clues?

15 Feb 2012, 3:31 AM
#39
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: Open a backup copy on LocalHost

Ran Fix_cache _Key again, no change.

I made sure the debug log was empty and tried getting to the Admin screen again (http://localhost/zencart/CUSTOM_ADMIN_NAME/login.php). No new entry.

The only editing I've done so far is rename the admin file, renamed the zc_install file, added the CUSTOM_ADMIN_NAME to CUSTOM_ADMIN_NAME/includes/configure.php.

Everything else that I've done relates to moving files from the downloaded copy of my website (public_html) to the local site.