MySQL Bugs: #40351: innobackup does not copy .ARZ and .ARM files

Bug #40351	innobackup does not copy .ARZ and .ARM files
Submitted:	27 Oct 2008 15:58	Modified:	2 Dec 2011 18:09
Reporter:	Elan Ruusamäe (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Backup	Severity:	S4 (Feature request)
Version:	5.0.67	OS:	Any
Assigned to:	Pekka Lampio	CPU Architecture:	Any
Tags:	Contribution

Description:
innobackup (http://www.innodb.com/support/documentation/innodb-hot-backup-manual/#innobackup
) does not copy data from ENGINE=ARCHIVE tables
tables when creating snapshot, which causes loss of data.

the missing files are .ARZ and .ARM extension

i've reported earlier missing TRG files in http://bugs.mysql.com/bug.php?id=26721

how many suprises are there coming?

How to repeat:
How to repeat:
0. create table foo with ENGINE=ARCHIVE
1. install ibbackup (evaluation version is ok) / innobackup from
http://www.innodb.com/order.php and http://www.innodb.com/manual.php#innobackup
2. run backup, ie:
# innobackup /etc/mysql/mysqld.conf --no-timestamp /var/tmp/innobackup
3. restore backup, ie:
# innobackup --apply-log /var/tmp/innobackup/backup-my.cnf /var/tmp/innobackup/
# mysqld --defaults-file=/var/tmp/innobackup/backup-my.cnf  --user=mysql
4. see that tables are corrupted
mysql> desc foo;

Suggested fix:
here's patch which makes innobackup perl script to include .TRN and .TRG files:
http://cvs.pld-linux.org/cgi-bin/cvsweb.cgi/SOURCES/innobackup-engine-archive.patch

This is a feature request.

Elan - Assuming you're interested in contributing to MySQL in general, you should sign the Sun|MySQL contributor agreement ... the SCA ... 

The instructions are given here:
http://forge.mysql.com/wiki/Sun_Contributor_Agreement

This is fixed in current version of MySQL Enterprise Backup