Error when executing from SQL file

Newbie Spellweaver
Joined
Jan 21, 2007
Messages
14
Reaction score
0
I get an error when i executing from a SQL file

FiR3F0X - Error when executing from SQL file - RaGEZONE Forums


There is an error log file from SQLyog

Code:
Query:


Error occured at:2007-03-05 15:08:32
Line no.:0
Error Code: 1049 - Unknown database 'mangos_bc'

Query:


Error occured at:2007-03-05 15:08:39
Line no.:0
Error Code: 1049 - Unknown database 'mangos_bc'

Query:


Error occured at:2007-03-05 15:08:59
Line no.:0
Error Code: 1049 - Unknown database 'mangos_bc'

Query:


Error occured at:2007-03-05 15:09:53
Line no.:0
Error Code: 1049 - Unknown database 'realmd_bc'

Query:
CREATE TABLE `account` (
 `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
 `username` varchar(16) NOT NULL default '',
 `password` varchar(28) NOT NULL default '',
 `gmlevel` tinyint(3) unsigned NOT NULL default '0',
 `sessionkey` longtext,
 `v` longtext,
 `s` longtext,
 `email` varchar(255) NOT NULL default '',
 `joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
 `banned` tinyint(3) unsigned NOT NULL default '0',
 `last_ip` varchar(30) NOT NULL default '127.0.0.1',
 `failed_logins` int(11) unsigned NOT NULL default '0',
 `locked` tinyint(3) unsigned NOT NULL default '0',
 `last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
 `online` tinyint(4) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `idx_username` (`username`),
 KEY `idx_banned` (`banned`),
 KEY `idx_gmlevel` (`gmlevel`)
 ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System'

Error occured at:2007-03-05 15:11:56
Line no.:34
Error Code: 1046 - No database selected
 
Back