Not the answer you need?
Register and ask your own question!

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

Alex_SaponovAlex_Saponov EntrantCurrent User Role Beginner
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: '[email protected]' 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 ,



Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.