US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > General technical discussion


Reply
 
Thread Tools
Old 09-10-2011, 09:23 PM   #1
Member
 
Join Date: Aug 2011
Posts: 31
Bt4 is on a distinguished road
Default 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
Bt4 is offline   Reply With Quote
Old 09-11-2011, 07:35 AM   #2
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

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
slava is offline   Reply With Quote
Old 09-11-2011, 07:47 PM   #3
Member
 
Join Date: Aug 2011
Posts: 31
Bt4 is on a distinguished road
Default

thanks, if fixed
Bt4 is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 03:46 PM.