-
Title
MySQL databases fail to backup with Failed to validate database -
Description
Netvault client Version 8.6.3
MySQL APM Version 4.1.5. I
MySQL Version 5.1.66.
When investigating the binary log entries below we see that all the database that fail to backup have the “-“ character in them.
From Binary log
Error 2012/12/07 22:09:53 415 Data Plugin KMI-WWWSVR03 Failed to validate database 'intent_uni-collaboration' in directory '/data/databases/mysql/intent_uni-collaboration'
-
Cause
From MySQL version 5.1* database that include the “-“ character will have this character changed as it a special character and will be encoded.
For example, if a database in MySQL 5.0 has a name of a-b-c, the name contains instance of the '-' character. In 5.0, the database directory is also named a-b-c, which is not necessarily safe for all file systems. In MySQL 5.1 and up, the same database name is encoded as a@002db@002dc to produce a file system-neutral directory name.
-
Resolution
This will be fixed under bug number 18405 check latest versions on MySQL plugin release notes to see if this bug has been fixed.
If the bug has not been fixed the only option at this time is to rename the MySQL database to a name that does not contain “-“ special character.
Below is a URL to a KB on how to rename the databases.
http://stackoverflow.com/questions/689451/how-can-we-rename-the-database-name-in-mysql-5-0When you rename the MySQL databases bear in mind that your permissions on the old DB will need to be deleted as well.
See here for more info: Revoke all privileges for all users on a MySQL DB
URL for revoke command
http://dev.mysql.com/doc/refman/5.1/en/revoke.html -
Defect ID
18405