Error import to mySQL, help please.....

[chrisj]

I exported a small database to my computer Desktop. A .sql file.
I asked my new web host to help me import it my new web mysql. I uploaded it and they attempted it directly to mysql(no phpmyadmin) and they replied "the importing of the backuped file to your database gives errors, and overwrites existing settings" and then provided the foloowing information below. Can someone help me tell me what this means and explain what went wrong and how this can be remedied? Thank you.

Query:
CREATE TABLE `accounts` (
`account_id` bigint(20) NOT NULL auto_increment,
`user_name` varchar(50) NOT NULL,
`first_name` varchar(100) NOT NULL default '',
`middle_initials` varchar(10) NOT NULL default '',
`last_name` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL,
`security_question` varchar(250) NOT NULL default '',
`security_question_answer` varchar(250) NOT NULL default '',
`email` varchar(200) NOT NULL,
`phone` varchar(100) NOT NULL default '',
`mobile_phone_number` varchar(100) NOT NULL default '',
`account_type_id` int(11) NOT NULL default '1',
`address` varchar(255) NOT NULL default '',
`address_second` varchar(255) NOT NULL default '',
`state` varchar(150) NOT NULL default '',
`city` varchar(150) NOT NULL default '',
`zip_code` varchar(150) NOT NULL default '',
`country_id` int(11) NOT NULL default '0',
`country_name` varchar(100) NOT NULL default '',
`status_id` int(11) NOT NULL default '1',
`status_title` varchar(50) NOT NULL,
`date_creation` date NOT NULL,
`date_last_login` date NOT NULL,
`user_agreement` varchar(20) NOT NULL,
`last_ip_address` varchar(20) NOT NULL,
`activation_code` varchar(100) NOT NULL default '',
`date_last_payment` date default NULL,
`terms` varchar(3) default 'yes',
`login_count` int(11) NOT NULL default '0',
PRIMARY KEY (`account_id`),
UNIQUE KEY `ix_accounts_email` (`email`),
UNIQUE KEY `ix_accounts_user_name` (`user_name`),
KEY `ix_accounts_first_name` (`first_name`),
KEY `ix_accounts_family_name` (`last_name`),
KEY `ix_accounts_country_id` (`country_id`),
KEY `ix_accounts_status_id` (`status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23

Error occured at:2007-10-01 19:26:42
Line no.:59
Error Code: 1050 - Table 'accounts' already exists

[itdevil]

Error Code: 1050 - Table 'accounts' already exists

the db in which you trying to import this backup in already have accounts table, try dropping/deleting it and do re-import.

[swordbeta]

Do the querry: "DROP TABLE accounts" first and try again.

[james_r]

i wouldn't just DROP the table... check what in it first, maybe better to append new data or rename/backup the old table? depends what's in it, what it's already being used for. don't go just dropping data if you're not sure whether you need it! :)