+1 (844) 533-0409

Recover corrupted or crashed MySQL database online

Earlier before we blogged about ways to recover corrupt MySQL database with TwinDB Data Recovery Toolkit. However learning curve of the toolkit is rather steep. It takes time to get familiar with InnoDB internals and the tool. And let’s be honest nobody gets prepared for data loss – people who prepare for disaster recovery take […]

Continue Reading »

Resolving page corruption in compressed InnoDB tables

Sometimes corruption is not the true corruption. Corruption in compressed InnoDB tables may be a false positive. Compressed InnoDB table may hit false checksum verification failure. The bug (http://bugs.mysql.com/bug.php?id=73689) reveals itself in the error log as follows:

InnoDB complains that a stored checksum is zero. If you look closely it’s suspicious that calculated checksum […]

Continue Reading »

Recover Corrupt MySQL Database

UPDATE: We announced online data recovery from corrupt databases. Check it out on https://recovery.twindb.com/ UPDATE (01/01/2017): We stopped further development of undrop-for-innodb and do not support its open source versions. The unDROP for InnoDB tool can be used to recover corrupt MySQL database. In this post we will show how to repair MySQL database if […]

Continue Reading »

Repair Corrupted InnoDB Table with Corruption in Secondary Index

UPDATE: We announced online data recovery from corrupt databases. Check it out on https://recovery.twindb.com/ UPDATE (01/01/2017): We stopped further development of undrop-for-innodb and do not support its open source versions. InnoDB provides no means to repair corrupted table space. Once a table got corrupt the only way to repair MySQL files is to start it […]

Continue Reading »
Loading...