Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    55
    Plugin Contributions
    0

    Default Error Importing Old Database

    Can anyone help me with this error. I can't seem to import my old database after dropping a table that I now want to get back (I backed up the site before I dropped the table). I get this error message:

    SQL query:

    --
    -- Database: `xxxxxxxx`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `address_book`
    --
    CREATE TABLE `address_book` ( `address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `customers_id` int( 11 ) NOT NULL default '0',
    `entry_gender` char( 1 ) NOT NULL default '',
    `entry_company` varchar( 32 ) default NULL ,
    `entry_firstname` varchar( 32 ) NOT NULL default '',
    `entry_lastname` varchar( 32 ) NOT NULL default '',
    `entry_street_address` varchar( 64 ) NOT NULL default '',
    `entry_suburb` varchar( 32 ) default NULL ,
    `entry_postcode` varchar( 10 ) NOT NULL default '',
    `entry_city` varchar( 32 ) NOT NULL default '',
    `entry_state` varchar( 32 ) default NULL ,
    `entry_country_id` int( 11 ) NOT NULL default '0',
    `entry_zone_id` int( 11 ) NOT NULL default '0',
    PRIMARY KEY ( `address_book_id` ) ,
    KEY `idx_address_book_customers_id_zen` ( `customers_id` )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =59;



    MySQL said:
    #1050 - Table 'address_book' already exists
    ---------------

    Can anyone help me figure out what I need to do to get my site back? Thanks so much!

    Lisa

  2. #2
    Join Date
    Apr 2007
    Posts
    55
    Plugin Contributions
    0

    Default Re: Error Importing Old Database

    Never mind! I figured it out.

    Created a new database and imported old database. Then changed the 2 configure files to point to the new database and VOILA!

    Lisa

 

 

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. Importing Data from Old Zen Database
    By rka81 in forum General Questions
    Replies: 3
    Last Post: 19 Oct 2011, 07:57 AM
  3. Trouble importing old database
    By countingsheep in forum Installing on a Windows Server
    Replies: 11
    Last Post: 12 Oct 2011, 05:37 AM
  4. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  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