Sunday, April 11, 2010

Table 'mysql.servers' doesn't exist after upgrade to mysql-5.1.45

SkyHi @ Sunday, April 11, 2010
This should solve the problem. Not sure how this problem started for me but I mysqldumped the mysql.server table from another database and eliminated the error.





Best,


C











CREATE TABLE `servers` (


`Server_name` char(64) NOT NULL,


`Host` char(64) NOT NULL,


`Db` char(64) NOT NULL,


`Username` char(64) NOT NULL,


`Password` char(64) NOT NULL,


`Port` int(4) DEFAULT NULL,


`Socket` char(64) DEFAULT NULL,


`Wrapper` char(64) NOT NULL,


`Owner` char(64) NOT NULL,


PRIMARY KEY (`Server_name`)


) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';


REFERENCE:
http://forums.mysql.com/read.php?11,142598,160503#msg-160503