-
Title
MYSQL Backup failed because the type of table [cond_instances] is not supported -
Description
NetVault server installation English
NetVault client installation German with language switched to English
One database selected but NetVault tries to backup all databases and fails backing up 'performance_schema' database.
Extract from binary log:
Information 2012/09/25 06:08:51 N/A GUI CO-LY-DC3 User 'default' Job id 1080 on F050PSRPZEALL01 rescheduled for immediate execution
Job Message 2012/09/25 06:08:51 1080 Data Plugin F050PSRPZEALL01 Plug-in: 'MySQL APM', Version: '4.1.5' Backup
Job Message 2012/09/25 06:10:50 1080 Data Plugin F050PSRPZEALL01 Successfully backed up file 'C:\ProgramData\MySQL\MySQL Server 5.5\Data\mysql\columns_priv.frm' for 'MyISAM' table 'columns_priv' for database 'mysql'.
Job Message 2012/09/25 06:10:50 1080 Data Plugin F050PSRPZEALL01 Backup of database 'mysql' was successful
Job Message 2012/09/25 06:10:50 1080 Data Plugin F050PSRPZEALL01 Beginning Backup of database: 'performance_schema' from server: 'F050PSRPZEALL01'
Error 2012/09/25 06:10:50 1080 Data Plugin F050PSRPZEALL01 Backup failed because the type of table [cond_instances] is not supported
-
Cause
Language compatibility problem
-
Resolution
NetVault server and NetVault client both must have the same language installation of NetVault. Changing the language to match after installation in the configurator will not resolve this problem.
1/ uninstall NetVault on the client
2/ install NetVault with the same language setting as the NetVault server
3/ install and setup MYSQL plugin
4/ create new MYSQL jobs and delete old MYSQL jobs for this client created with previous setup