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

  • Filter
  • Time
  • Show
Clear All
new posts

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

    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 ,


  • #2

    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.