Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    May 2005
    Posts
    49
    Plugin Contributions
    0

    Default Transfering Databases/Products

    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.

  2. #2
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,888
    Plugin Contributions
    0

    Default Re: Transfering Databases/Products

    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
    Mike
    AEIIA - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  3. #3
    Join Date
    May 2005
    Posts
    49
    Plugin Contributions
    0

    Default Re: Transfering Databases/Products

    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?

  4. #4
    Join Date
    Dec 2005
    Location
    Cincinnati Ohio
    Posts
    1,026
    Plugin Contributions
    13

    Default Re: Transfering Databases/Products

    look at the file includes/configure.php find where it says
    Code:
    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
    Last edited by knuckle-101; 8 Nov 2006 at 04:39 AM.
    PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
    Business Class Web Hosting - Linux and cPanel Powered

  5. #5
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,888
    Plugin Contributions
    0

    Default Re: Transfering Databases/Products

    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

    Code:
     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 *
    Mike
    AEIIA - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Transfering Databases/Products

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. copy products between databases
    By ricardino in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 22 Sep 2009, 02:46 PM
  2. Transfering products to a NEW Zen Cart
    By QueenKat in forum General Questions
    Replies: 5
    Last Post: 19 Apr 2007, 05:49 PM
  3. Transfering Categories and Products
    By theangel2g in forum General Questions
    Replies: 5
    Last Post: 15 Mar 2007, 06:20 PM
  4. Transfering Products From One Zen Cart To Another
    By hudda in forum General Questions
    Replies: 3
    Last Post: 26 Jan 2007, 06:32 AM
  5. Products not transfering to 2checkout
    By getaway in forum Addon Payment Modules
    Replies: 1
    Last Post: 4 Oct 2006, 03:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg