-
Clean DB Erroring?
EDIT: Ope, guess I should of said so in the title, but this is for the Antrix core.
I'm trying real hard to get a decently up to date core revision and database running. I'm still really new to this so obviously, very little makes sense. I've got SQL and SQLyog working fine and all of that so the next step is find a core. I got antrix256 from
Code:
http://www.newguardia.net/antrix-win32/
and in just messing around, I try to restore the clean_db.sql file thinking that, by the name, it is just an empty db with placeholders for all of the tables. In trying to restore it, I get to something like 3k and it errors with this:
Code:
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-06-13 00:33:22
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-06-13 00:34:58
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-06-13 01:05:54
Line no.:44
Error Code: 1050 - Table 'ai_agents' already exists
and the list goes on and on. All I did was delete what DB I had in there, made a new one called Antrix, and I go to restore the file.
Does this file not do what I think it did? Did I do something wrong? :frusty:
I hadn't even gotten to the part about finding a database that I feel good enough about it being up to date and working yet. If anyone could help me out here, I'd appreciate it.
-
Re: Clean DB Erroring?
That empty database it's not good ..just leave it and search for ragecraft or some other full database..i am still waiting for a good database.
-
Re: Clean DB Erroring?
yeah the db guys are doing their best and all we can do is wait, keep up the awesome work i say