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:
Category:MySQL Enterprise Backup Severity:S4 (Feature request)
Version:5.0.67 OS:Any
Assigned to: Pekka Lampio CPU Architecture:Any
Tags: Contribution

[27 Oct 2008 15:58] Elan Ruusamäe
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:
[30 Oct 2008 14:56] Heikki Tuuri
This is a feature request.
[26 May 2009 9:01] Masood Mortazavi
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:
[2 Dec 2011 18:09] Sveta Smirnova
This is fixed in current version of MySQL Enterprise Backup