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:
and this patch for it:
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.