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

MySQL & MariaDB Percona XtraBackup
1

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.

2

Hi,

ibbackup_binlog_marker was used in MEB. (MySQL Enterprise Backup) [url]https://www.mysql.com/products/enterprise/backup.html[/url]
There is also a bug related to DROP that table. [url]MySQL Bugs: #54053: Drop table mysql.ibbackup_binlog_marker crashes the server for innodb plugin

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? :slight_smile: There are many features in latest versions.