-
Titolo
Mysql database backup failed on selected tables. -
Descrizione
MySQL database backups are successful for most, but not all databases.
Most tables backup ok:
Job Message 2011/10/21 00:01:27 40 Data Plugin MySQL-client Successfully backed up 'InnoDB' table 'tableA' for database 'DB'.
But certain databases fail with errors similar to:
Error 2011/10/21 00:02:38 40 Data Plugin MySQL-client Failed to backup 'InnoDB' table 'tableB' for database 'DB'.
-
Causa
When most tables backup successfully, but there are failures in certain individual tables, then it is almost always caused by problems in the tables themselves. Usually a permissions error.
,
-
Risoluzione
Check the table individually by running mysqldmp exactly the same way NetVault plugin does it, using exactly the same user as configured in the NetVault plugin. This is an example:
./mysqldump --skip-triggers --add-locks --no-data=FALSE --socket="/tmp/mysql.sock" --max_allowed_packet=1048576 --add-drop-table --skip-comments --single-transaction --extended-insert --quote-names --quick --user="USER NAME" --password="BLAH BLAH" --default-character-set="latin1" --tables -- "DB NAME" "TABLE NAME"
This command will error with a standard MySQL error code that should be straightforward to track.