Hot Backup with innobackupex-1.5.1 fails with error : "ibbackup_binlog_marker"

[Alex_Saponov]

HI ,
I’M Running MySQL 4.0.27 Production Environment On CentOS 5.2 64 Bit , The Hot Backup Performed by the “xtrabackup-0.6-1.rhel5” with the innobackupex-1.5.1 tool, The Server is without replicaiton / binlog in my.cnf

Somehow the backup failed on error :

"innobackupex: Error: mysql child process has died: ERROR 1142 (HY000) at line 5: DROP command denied to user: ‘percona@localhost’ for table ‘ibbackup_binlog_marker’
while waiting for reply to MySQL request: 'DROP TABLE IF EXISTS ibbackup_binlog_marker;’ at /usr/bin/innobackupex-1.5.1 line 433.

When i run the backup with user that has “Drop Tables” privileges ,backup ends successfully.

I’m not aware to the term “'DROP TABLE IF EXISTS ibbackup_binlog_marker” my question , What is the table above,
Are it can be critical / Impact the Database when this table dropped?

Thank You ,

Alex.

[niljoshi]

Hi,

ibbackup_binlog_marker was used in MEB. (MySQL Enterprise Backup) https://www.mysql.com/products/enterprise/backup.html
There is also a bug related to DROP that table. http://bugs.mysql.com/bug.php?id=54053

But it you are using Percona Toolkit (Xtrabackup/Innobackupex) then I don’t think you need to worry about that table.
Just curious, why you are using so…old version of MySQL? There are many features in latest versions.