By Maksym Kryva.
If you don’t verify backups you may safely assume you don’t have them.
It often happens that MySQL backups can be invalid or broken due
to a software bug, or some hidden corruption. If you are lucky
enough, hours and days will be needed to resurrect a database
from a bad backup copy. If you ran out of luck quota, you may
lose a lot of data. Hence the importance of data backup
verification. Not many companies do backups, and even less verify
them. To make the verification problem easier, we have added a
verify command to the TwinDB Backup
What the command does is that it takes a backup copy, restores it, prepares (applies redo logs, fixes permissions and so on) and runs a MySQL instance on it. Then it checks if the recovered database is healthy. You can …[Read more]