Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Sep 2006
    Posts
    154
    Plugin Contributions
    0

    Default Re: Trouble importing old database

    muddkids_nonupgradezc.zen_address_book OK
    muddkids_nonupgradezc.zen_address_format OK
    muddkids_nonupgradezc.zen_admin OK
    muddkids_nonupgradezc.zen_admin_activity_log OK
    muddkids_nonupgradezc.zen_authorizenet OK
    muddkids_nonupgradezc.zen_banners OK
    muddkids_nonupgradezc.zen_banners_history OK
    muddkids_nonupgradezc.zen_categories OK
    muddkids_nonupgradezc.zen_categories_description OK
    muddkids_nonupgradezc.zen_configuration OK
    muddkids_nonupgradezc.zen_configuration_group OK
    muddkids_nonupgradezc.zen_counter OK
    muddkids_nonupgradezc.zen_counter_history OK
    muddkids_nonupgradezc.zen_countries OK
    muddkids_nonupgradezc.zen_coupon_email_track OK
    muddkids_nonupgradezc.zen_coupon_gv_customer OK
    muddkids_nonupgradezc.zen_coupon_gv_queue OK
    muddkids_nonupgradezc.zen_coupon_redeem_track OK
    muddkids_nonupgradezc.zen_coupon_restrict OK
    muddkids_nonupgradezc.zen_coupons OK
    muddkids_nonupgradezc.zen_coupons_description OK
    muddkids_nonupgradezc.zen_currencies OK
    muddkids_nonupgradezc.zen_customers OK
    muddkids_nonupgradezc.zen_customers_basket OK
    muddkids_nonupgradezc.zen_customers_basket_attributes OK
    muddkids_nonupgradezc.zen_customers_info OK
    muddkids_nonupgradezc.zen_customers_wishlist OK
    muddkids_nonupgradezc.zen_db_cache OK
    muddkids_nonupgradezc.zen_email_archive OK
    muddkids_nonupgradezc.zen_ezpages OK
    muddkids_nonupgradezc.zen_featured OK
    muddkids_nonupgradezc.zen_files_uploaded OK
    muddkids_nonupgradezc.zen_geo_zones OK
    muddkids_nonupgradezc.zen_get_terms_to_filter OK
    muddkids_nonupgradezc.zen_group_pricing OK
    muddkids_nonupgradezc.zen_languages OK
    muddkids_nonupgradezc.zen_layout_boxes OK
    muddkids_nonupgradezc.zen_manufacturers OK
    muddkids_nonupgradezc.zen_manufacturers_info OK
    muddkids_nonupgradezc.zen_media_clips OK
    muddkids_nonupgradezc.zen_media_manager OK
    muddkids_nonupgradezc.zen_media_to_products OK
    muddkids_nonupgradezc.zen_media_types OK
    muddkids_nonupgradezc.zen_meta_tags_categories_description OK
    muddkids_nonupgradezc.zen_meta_tags_products_description OK
    muddkids_nonupgradezc.zen_music_genre OK
    muddkids_nonupgradezc.zen_newsletters OK
    muddkids_nonupgradezc.zen_nochex_apc_transactions OK
    muddkids_nonupgradezc.zen_nochex_sessions OK
    muddkids_nonupgradezc.zen_orders OK
    muddkids_nonupgradezc.zen_orders_products OK
    muddkids_nonupgradezc.zen_orders_products_attributes OK
    muddkids_nonupgradezc.zen_orders_products_download OK
    muddkids_nonupgradezc.zen_orders_status OK
    muddkids_nonupgradezc.zen_orders_status_history OK
    muddkids_nonupgradezc.zen_orders_total OK
    muddkids_nonupgradezc.zen_paypal OK
    muddkids_nonupgradezc.zen_paypal_payment_status OK
    muddkids_nonupgradezc.zen_paypal_payment_status_history OK
    muddkids_nonupgradezc.zen_paypal_session OK
    muddkids_nonupgradezc.zen_paypal_testing OK
    muddkids_nonupgradezc.zen_product_music_extra OK
    muddkids_nonupgradezc.zen_product_type_layout OK
    muddkids_nonupgradezc.zen_product_types OK
    muddkids_nonupgradezc.zen_product_types_to_category OK
    muddkids_nonupgradezc.zen_products OK
    muddkids_nonupgradezc.zen_products_attributes OK
    muddkids_nonupgradezc.zen_products_attributes_download OK
    muddkids_nonupgradezc.zen_products_description OK
    muddkids_nonupgradezc.zen_products_options OK
    muddkids_nonupgradezc.zen_products_options_types OK
    muddkids_nonupgradezc.zen_products_options_values OK
    muddkids_nonupgradezc.zen_products_options_values_to_products_options OK
    muddkids_nonupgradezc.zen_products_to_categories OK
    muddkids_nonupgradezc.zen_products_with_attributes_stock OK
    muddkids_nonupgradezc.zen_project_version OK
    muddkids_nonupgradezc.zen_project_version_history OK
    muddkids_nonupgradezc.zen_query_builder OK
    muddkids_nonupgradezc.zen_record_artists OK
    muddkids_nonupgradezc.zen_record_artists_info OK
    muddkids_nonupgradezc.zen_record_company OK
    muddkids_nonupgradezc.zen_record_company_info OK
    muddkids_nonupgradezc.zen_reviews OK
    muddkids_nonupgradezc.zen_reviews_description OK
    muddkids_nonupgradezc.zen_salemaker_sales OK
    muddkids_nonupgradezc.zen_sessions OK
    muddkids_nonupgradezc.zen_specials OK
    muddkids_nonupgradezc.zen_subscribers OK
    muddkids_nonupgradezc.zen_tax_class OK
    muddkids_nonupgradezc.zen_tax_rates OK
    muddkids_nonupgradezc.zen_template_select OK
    muddkids_nonupgradezc.zen_upgrade_exceptions OK
    muddkids_nonupgradezc.zen_whos_online OK
    muddkids_nonupgradezc.zen_zen_upgrade_exceptions OK
    muddkids_nonupgradezc.zen_zones OK
    muddkids_nonupgradezc.zen_zones_to_geo_zones OK

  2. #12
    Join Date
    Jan 2004
    Posts
    66,380
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Trouble importing old database

    Quote Originally Posted by countingsheep View Post
    now, I am getting this message:

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


    the configuration table does exist? I dont know what I did wrong there?
    Quote Originally Posted by countingsheep View Post
    muddkids_nonupgradezc.zen_categories OK
    muddkids_nonupgradezc.zen_categories_description OK
    muddkids_nonupgradezc.zen_configuration OK
    "configuration" is entirely different than "zen_configuration".

    Looks like your old server used a DB_PREFIX of "zen_", and your new site is using a blank "" instead.

    If you're going to import tables from another database, you must make the new DB_PREFIX match whatever was used on the previous server.

    Ensure both of your configure.php files has the correct DB_PREFIX setting to match the data you've imported.
    .

    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.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Error importing old database to the new database
    By wmorris in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 3 Jan 2012, 08:27 AM
  2. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  3. Having trouble importing my database
    By pharry in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 22 Jun 2009, 11:14 AM
  4. Error Importing Old Database
    By brikat in forum General Questions
    Replies: 1
    Last Post: 2 May 2008, 11:27 PM
  5. Importing Old Database?
    By powerline5 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 7 Mar 2007, 05:34 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR