Zen Cart Logo
Forums / Installing on a Windows Server / Localhost Installation - can't import database

Localhost Installation - can't import database

Locked

Started by sue4ster on 2 Oct 2006, 6:13 AM · Views: 2,484

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
2 Oct 2006, 6:13 AM
#1
sue4ster avatar

sue4ster

New Zenner

Join Date:
Apr 2006
Location:
Halfway, Oregon
Posts:
47
Plugin Contributions:
0

Localhost Installation - can't import database

I have XAMPP running as localhost on my Windows XP Pro machine, and have successfully installed Zen Cart 1.3.5 several times with the intent to practice with things like the improved attributes controller, Image Handler, etc. I set permissions by going to the appropriate files/folders in htdocs and ticking or unticking 'read only'.

I have been trying to import my database from my live site (Version 1.3.2) using my most recent back up copy.

I named the database the same as the live one when I installed the localhost Zen Cart. The database imports in phpMyAdmin (localhost), but does not show up in the store.

../store/includes/configure.php
../store/admin/includes/configure.php
both correctly state the database name.

XAMPP has PHP Version 5.1.6; MySQL 5.0.24a-community
Host has PHP Version 4.4.3; MySQL 4.1.21-standard
If that makes any difference.

I don't know what I'm doing wrong, or where to look to figure this out. This is my first experience with databases.

Would sure appreciate a bit of direction so I can get this going.

TIA,
Sue

- Oregon Sue - Oregon Web Designs

3 Oct 2006, 8:37 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: Localhost Installation - can't import database

Do both databases use the same table-prefixes (if any)?

If so, then you most likely have a version-conflict in your MySQL export/import process, such that the format of the export version isn't compatible with the required format for your import version. To find out, do an export of your "admin" table, from both systems, and post the results here. There will be a need to reconcile the differences.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Oct 2006, 9:00 PM
#3
drbyte avatar

drbyte

Sensei

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

Re: Localhost Installation - can't import database

Hmmm ... I see you have resolved the issue in your duplicate post on the same topic:
http://www.zen-cart.com/forum/showthread.php?p=270853

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.