Need Help Importing SQL Tables To New DB

[harryedwards]

I'm in the process of switching hosting companies so I:

 

1. did a fresh install of oscommerce (oscommerce-2.2rc2a)

2. Tried importing data from current store to new store. To be careful I'm trying to do this one table at a time. Each time I try this I get the following error:

 

Error

SQL query:

# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Feb 21, 2008 at 09:13 PM
# Server version: 4.0.18
# PHP Version: 4.3.2
# 
# Database : `acom_store`
# 
# --------------------------------------------------------
#
# 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` ( `customers_id` )

) TYPE = MYISAM AUTO_INCREMENT =481;


MySQL said:

#1050 - Table 'address_book' already exists

 

I realize the message at the bottom says that this table already exists. I know that but I thought I was just replacing this table with the one I was trying to import. Would someone please help me find a solution to this. Thanks.

[CoSmis]

http://www.oscommerce.com/forums/lofiversion/i...hp?t233718.html

[Rick4259]

I'm in the process of switching hosting companies so I:

 

1. did a fresh install of oscommerce (oscommerce-2.2rc2a)

2. Tried importing data from current store to new store. To be careful I'm trying to do this one table at a time. Each time I try this I get the following error:

 

Error

SQL query:

# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Feb 21, 2008 at 09:13 PM
# Server version: 4.0.18
# PHP Version: 4.3.2
# 
# Database : `acom_store`
# 
# --------------------------------------------------------
#
# 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` ( `customers_id` )

) TYPE = MYISAM AUTO_INCREMENT =481;


MySQL said:

#1050 - Table 'address_book' already exists

 

I realize the message at the bottom says that this table already exists. I know that but I thought I was just replacing this table with the one I was trying to import. Would someone please help me find a solution to this. Thanks.

 

 

If I understand you correctly you have reinstalled osCommerce and it of course has populated the database.

Now you are trying to reinstall your old database and coming up with sql errors primarily that the table already exists.

The simplest solution is to go into your database and delete all the tables present there, the try reinstalling your old database.

 

Before doing this be sure you back everything up. This procedure has worked for me but then I am not a expert when it comes to sql.

[♥geoffreywalton]

Or when you dump/export the data from the old db specify it should create the drop table commands as part of the export file.