-
Enthusiast
Excecute batch file error
When I try to excecute my batch file with navicat, I get this screen, but I don't think it should appear like this. should it?
[Err] 1050 - Table 'accounts' already exists
[Err] -- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(64) default NULL,
`password` varchar(32) default NULL,
`accesslevel` int(11) default '100',
`lastip` varchar(15) default '0.0.0.0',
`lasttime` int(11) default '0',
`lastsvr` int(11) default '0',
`lastchar` varchar(64) default NULL,
`email` varchar(100) default NULL,
`nb_donation` int(11) default '0',
`donation` varchar(255) default '0',
`active` int(11) default '1',
`active_key` varchar(255) default NULL,
`zulystorage` int(11) default '0',
`platinum` tinyint(1) default '0',
`online` tinyint(1) default '0',
`login_count` int(11) default '0',
`isSiteLogged` tinyint(1) default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
-
-
Account Upgraded | Title Enabled!
Re: Excecute batch file error
That means you already have the table in the database. You could add DROP TABLE IF EXIST `accounts`; and it would work. Take in mind that you'll have to do that with all the pre-existing tables you want to replace. Or you could just delete all the tables there and then execute the SQL file.