[Help]MySQLyog Databases

[psychochild09]

ok so i was going top execute the after recovering the mangos_bc.sql file but i got this error can anyone help?


Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'
Error occured at:2007-03-23 20:48:00
Line no.:18
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

 

[dufus]

Looks like the table already exists. If you are installing a new db you have to delete the old one first. Make sure you backup any saves first.

 

[psychochild09]

how do i delete the old one?

 

[dufus]

What are you using to apply the upgrade? Navicat, SQLyog?

 

[psychochild09]

SQLyog

 

[dufus]

just open the mangos db and find the table and delete it.

 

[psychochild09]

in SQLyog?