Change Is InevitableRestore A Table / Database From Full Backup – Yet Another Way
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.
Tag: mysql recovery
A tale of Corrupt InnoDB table, MySQL crash & recovery
I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator detected the issue and what he did to resolve it. A day in MySQL Database Consultant’s day was taking its shape while a friend called […]
Restore / Recover dropped MySQL database from binary logs
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. Recently someone accidentally dropped an important MySQL database and the backup was not present! As we know the the binary log contains DMLs to table data and that’s where our hope lies. Luckily the binary log retention […]