Transfering Databases/Products

[LyttonFinds]

I've been trying to transfer databases for days now and the result.. i lost one of the sites and i'm having to upload zencart all over again. I've read on here how to do it and stuff but I'm sooo lost I guess.

All I want to do is take just the products from one zencart site and put them in th other zencart site.

I did figure out the backup download so atleast now I can just restore rather than losing a site completely..

please tell me this is a simple process and I'm just not seeing it.

[barco57]

you would use phpMyAdmin and export just the products tables to a file and then go to the Db you want to move the products to and import that same file. I'm not sure if you have to drop the current tables in the importing DB before importing or if it will just overwrite or not. Somebody with more experience than me will pipe up I'm sure

[LyttonFinds]

Okay in the phpMyAdmin.. where do I find the product tables? I mean, I see all these Product options.. how do I know which one is the one that holds the products?

[knuckle-101]

look at the file includes/configure.php find where it says

define('DB_DATABASE', '');

The name of the database will be in between ' '

To export click on the db you want in phpMYadmin and then click export, choose your option at the bottom of the page, gzip, or none then submit and that will export the file for you and then save it to your desktop in desired location.

Good Luck

[barco57]

This is from the wiki it is a list of the "product info" tables. You will need all of these when copying products to another DB. hope this helps

 Product Info

    categories 
    categories_description 
    product_type_layout * 
    product_types * 
    product_types_to_category * 
    products * 
    products_attributes * 
    products_attributes_download * 
    products_description * 
    products_discount_quantity * 
    products_options * 
    products_options_types 
    products_options_values * 
    products_options_values_to_products_options * 
    products_to_categories * 
    manufacturers 
    manufacturers_info 
    meta_tags_products_description 
    meta_tags_categories_description 
    reviews * 
    reviews_description *

[Ajeh]

Then there are the "special" tables on the products:
specials
featured
salemaker_sales

Then if using the Product Music type there is a whole host of other tables involved ...

Plus if using the Product Types and separating Categories then there is another series of tables ...

You really want to be sure to backup before attempting anything like this as it is easy to leave behind important tables ...