I’m trying to prepare my backup to restore on another server and I have
InnoDB: End of page dump
2014-06-23 06:36:45 7f40e17c3700 InnoDB: uncompressed page, stored checksum in field1 3735928559, calculated checksums for field1: crc32 177807968, innodb 3475755373, none 3735928559, stored checksum in field2 3735928559, calculated checksums for field2: crc32 177807968, innodb 1624572976, none 3735928559, page LSN 0 0, low 4 bytes of LSN at page end 0, page number (if stored to page already) 0, space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be a freshly allocated page
2014-06-23 06:36:45 7f40e17c3700 InnoDB: Assertion failure in thread 139916637648640 in file rem0rec.cc line 577
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: about forcing recovery.
innobackupex: ibbackup failed at /usr/bin/innobackupex line 2610.
If I try to restore it by table it also error
Internal error: Cannot reset LSNs in table ‘“hero_db”.“map_save”’ : Data structure corruption */
It seems that is because there are no exp file.
command for prepare
innobackupex --apply-log --export /var/mysql-backup/2014-06-20_10-00-01
command for create backup
innobackupex --user= --password= --compact --databases=“hero_db” /var/mysql-backup
Probably it is because we use COMPRESSED tables