JoomlaPlug!

Exported ok, included 'Drop tables' as an option. If I look in the database-sql.sql file, the drop statements are in there:

# Table structure for table `jos_banner`
#
#
DROP table IF EXISTS jos_banner;
CREATE TABLE `jos_banner` (
...
...

However, when I try to restore the database on another host, it seems like it doesn't drop the tables and then it can't import any of the data as there already exists data. This is the error I get:

There were some errors while importing the database:
##Mysql Query:
########
CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(10) NOT NULL default 'banner', `name` varchar(50) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`));
########
##Error message: Table 'jos_banner' already exists


##Mysql Query:
########
INSERT INTO jos_banner VALUES ('1','1','banner','OSM 1','0','96','0','osmbanner1.png','http://www.opensourcematters.org','2004-07-07 15:31:29','1','0','0000-00-00 00:00:00','',''
########
##Error message: Duplicate entry '1' for key 1


This goes on and on and in the end no data is imported. What can be wrong?