Sometimes the operating system or the hardware can corrupt a data file page, in a location that does not cause a database error but prevents mysqlbackup from completing:
mysqlbackup: Re-reading page at offset 0 3185082368 in /sqldata/mts/ibdata15 bbackup: Re-reading page at offset 0 3185082368 in /sqldata/mts/ibdata15 bbackup: Error: page at offset 0 3185082368 in /sqldata/mts/ibdata15 seems corrupt!
A corruption problem can have different causes. Here are some suggestions for dealing with it:
The problem can occur if the MySQL server is too busy. Before trying other solutions, you might want to perform the backup again using some non-default settings for the following mysqlbackup options:
Scrambled data in memory can cause the problem even though the data on disk is actually uncorrupted. Reboot the database server and the storage device to see if the problem persists.
If the problem persists after the database server and the storage device have been restarted, you might really have a corruption on your disk. You might consider restoring data from an earlier backup and "roll forward" the recent changes to bring the database back to its current state.
If you want to make MySQL Enterprise Backup finish a backup anyway before you go and investigate the root cause of the issue, you can rewrite the checksum values on the disk by running the innochecksum utility on the server:
innochecksum --no-checksum --write=crc32
--no-checksum disable the
verification function of the tool, and the option
innochecksum rewrite the
checksum values on the disk.
IMPORTANT: Do not treat corruption problems as a minor annoyance. Find out what is wrong with the system that causes the corruption—however, such troubleshooting is beyond the scope of this manual.