ISPsystem.com Forums

ISPsystem.com Forums (http://forum.ispsystem.com//index.php)
-   General technical discussion (http://forum.ispsystem.com//forumdisplay.php?f=8)
-   -   Table 'mysql.servers' doesn't exist (http://forum.ispsystem.com//showthread.php?t=1519)

Bt4 09-10-2011 09:23 PM

Table 'mysql.servers' doesn't exist
 
: Failed to create temp user pbkp_317200: ERROR 1146 (42S02) at line 5: Table 'mysql.servers' doesn't exist

when i want restore website from Emport section
cant restore database get this error

slava 09-11-2011 07:35 AM

Are you have upgrade mysql server version? Try run mysql_fix_privilege_tables for fix this
Or create this table in mysql database 'mysql' manually


Code:

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';


http://www.google.com/search?aq=f&so...sn't+exist

Bt4 09-11-2011 07:47 PM

thanks, if fixed


All times are GMT +2. The time now is 11:55 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.