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?

Hi there! You need to check using phpmyadmin if your mysql user is allowed to execute DROP queries!

In any case, if you still have issue, I simply advise to empty the database manually or create an empty one and retry again!

Let me know if you have further issues! Regards, Ovidiu