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 ,