Error when executing from SQL file
I get an error when i executing from a SQL file
http://shrani.si/files/screenshotv0xp.jpg
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
Re: Error when executing from SQL file
create a new database in sqlyog named mangos_bc and then import mangos_bc.sql
Re: Error when executing from SQL file
