So I’m having this problem:
I have a 64 bit system with ibd files >80 gigs.
It has no problem backing up and restoring to a 32 bit test system.
Now when backing up the restored system (the 32 bit system) using this command:
innobackupex-1.5.1 --user=root --password=**** --no-lock --stream=tar ./ | gzip - > /data/dbackup/mysql/testzz/zztest1.tar.gz
It says backup completed fine but the tar.gz has all kinds of errors in it and will not restore. I used the tar xvfi option.
This happens on two of the 32-bit system i’m testing with.
Otherwise the databases seem fine but it will not back up properly!.
I have found this person having the exact same issue:
http://groups.google.com/group/percona-discussion/browse_thr ead/thread/9b9393281b3dcb5
and this patch for it:
[URL=“https://Bug #690822 “Tar4ibd silently fails to send entire backup” : Bugs : Percona XtraBackup moved to https://jira.percona.com/projects/PXB”]https://bugs.launchpad.net/percona-xtrabackup/+bug/690822[/URL]
how do I implement this patch? I am running Ubuntu 10.10 and I downloaded xtrabackup from the percona site using the ‘lucid’ binary.
Again restoring is no problem, everything works, the backup (of the restore on a 32 bit system) seems to be the problem.