Zen Cart Logo
Forums / General Questions / SQL Import (restore) Not Listing Products

SQL Import (restore) Not Listing Products

Locked

Views: 1,213

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
3 Feb 2009, 6:06 PM
#1
nvcrossroads avatar

nvcrossroads

New Zenner

Join Date:
Feb 2009
Posts:
13
Plugin Contributions:
0

SQL Import (restore) Not Listing Products

I need a clean install of my zen-cart. However, I don't want to lose my products. I've completed a back up of my SQL database and through the php admin cpanel I've imported to the new database. All categories and tables are showing up but not products.

Does this mean I need the easy populate mod or am I doing the import incorrectly?

Thanks!

3 Feb 2009, 9:36 PM
#2
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,284
Plugin Contributions:
37

Re: SQL Import (restore) Not Listing Products

Open the SQL and paste the products tables in to phpMyadmin in the SQL tab

~Melanie

4 Feb 2009, 12:37 AM
#3
nvcrossroads avatar

nvcrossroads

New Zenner

Join Date:
Feb 2009
Posts:
13
Plugin Contributions:
0

Re: SQL Import (restore) Not Listing Products

Thanks. When I open the SQL and click on the SQL tab I see this: Run SQL query/queries on database saltc2_zc1:

[ Delimiter ] Show this query here again Open new phpMyAdmin window

I don't understand how I would "paste the tables" from the one database to the other....

4 Feb 2009, 2:45 AM
#4
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,284
Plugin Contributions:
37

Re: SQL Import (restore) Not Listing Products

You would open your SQL backup and select the products tables and paste them in box in the sql tab and hit go.

You might want to ask your hosting company to help you.

~Melanie

5 Feb 2009, 12:57 AM
#5
nvcrossroads avatar

nvcrossroads

New Zenner

Join Date:
Feb 2009
Posts:
13
Plugin Contributions:
0

Re: SQL Import (restore) Not Listing Products

Thank you. Although Lunarpages was unable to assist me further I was able to receive step by step instructions here:

https://www.zen-cart.com/tutorials/index.php?article=103

Thanks again!

5 Feb 2009, 1:04 AM
#6
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,284
Plugin Contributions:
37

Re: SQL Import (restore) Not Listing Products

WTG :clap:

~Melanie