mysqlhotcopy fails to backup all databases
I'm using the mysql backup to do a hotcopy backup of all databases (Mysql 5.1.41 on Ubuntu Lucid). I'd rather have them all tried so that they're all covered automatically. Unfortunately, a bug in Mysql causes the mysqlhotcopy to fail when it tries to lock the log tables.
Mysql bug: http://bugs.mysql.com/bug.php?id=30487
backupninja output: Info: Initializing hotcopy method Warning: DBD::mysql::db do failed: You can't use locks with log tables. at /usr/bin/mysqlhotcopy line 452. Warning: Failed to hotcopy all mysql databases
I appreciate that this is really a mysql bug, but I was wondering if the mysql handler in backupninja could avoid it somehow?
(from redmine: created on 2011-04-28, closed on 2011-04-28)