No character table??

[**Sweeny**]

just used a datavase ich had 2 SQL files in it ascent and character cant copy the character file into it and getting this error

Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-16 09:27:47
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 12:48:29
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 12:48:35
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 12:48:42
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 12:48:52
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 12:50:10
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 12:50:26
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `accountdata0` text NOT NULL,
  `accountdata1` text NOT NULL,
  `accountdata2` text NOT NULL,
  `accountdata3` text NOT NULL,
  `accountdata4` text NOT NULL,
  `accountdata5` text NOT NULL,
  `accountdata6` text NOT NULL,
  `accountdata7` text NOT NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 12:52:10
Line no.:26
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `banned_names` (
  `name` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 14:53:04
Line no.:116
Error Code: 1050 - Table 'banned_names' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `uiconfig0` blob,
  `uiconfig1` blob,
  `uiconfig2` blob,
  `uiconfig3` blob,
  `uiconfig4` blob,
  `uiconfig5` blob,
  `uiconfig6` blob,
  `uiconfig7` blob,
  `uiconfig8` blob,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `a` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 15:33:30
Line no.:27
Error Code: 1050 - Table 'account_data' already exists
Query:
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `uiconfig0` blob,
  `uiconfig1` blob,
  `uiconfig2` blob,
  `uiconfig3` blob,
  `uiconfig4` blob,
  `uiconfig5` blob,
  `uiconfig6` blob,
  `uiconfig7` blob,
  `uiconfig8` blob,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `a` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2008-01-17 15:37:15
Line no.:27
Error Code: 1050 - Table 'account_data' already exists

[Le Froid]

The table already exists
P.S. Don't double post

[Spartansp]

lol the as le froid said table already exist just delete existing tables and run again the querry :P

[**Sweeny**]

trying to import 2 SQL files so deleting table will help that :S?

[Spartansp]

yes... delete ONLY the existing table and run querry again...

[**Sweeny**]

Nope still not working once I go empty database then upload the ascent SQL file again, then I attempt to to put character SQL file still same error now the accounts table is gone??? :S

[Le Froid]

Do acct table one FIRST

[Spartansp]

maybe your ascent sql has a duplicate table
you can test that it has duplicate just executing first character then ascent and same error will appear... just delete the suplicate table NOT ENTIRE DATABASE just the duplicate table in you database and run character

[**Sweeny**]

The first character SQL install worked then i installed ascent then it gave me the error, and dont get what you're saying spart... (huge n00b at making these atm.) went into SQLyog all tables from character are currently there :P hey spart can you post a pic of what you mean I dont have a duplicated table??

[Spartansp]

yes you have a duplicate table so thats the error you get :
Error Code: 1050 - Table 'account_data' already existsdo you see... just delete that table account_data and run ascent querry

[**Sweeny**]

so first what do i put into my ascent folder the ascent SQL or the character SQL?????

[Spartansp]

first ascent... then errase accounts_data table and execute characters...
if you dont understand this... ill give up...

[**Sweeny**]

yeah, I get that but when i put import ascent SQL folder it doesnt have account_data table..it had it b4 but not nw...