Category Archives : MySQL Data Recovery
Percona Live is a Christmas in MySQL world. It’s time when all friends and family gather over a glass of beer. Everyone is talking about achievements of the last year and make New Year resolutions for a next one. There will be two talks from TwinDB this year. One is about data recovery and one […]
Continue Reading »
Not so long ago I had a customer who experienced data loss after MySQL restart. It was really puzzling. MySQL was up & running for many months, but after the customer restarted MySQL server all tables have gone. The tables were still visible in SHOW TABLES output, but they were not readable:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
mysql> show tables like 'actor'; +--------------------------+ | Tables_in_sakila (actor) | +--------------------------+ | actor | +--------------------------+ 1 row in set (0.00 sec) mysql> select * from actor; ERROR 1146 (42S02): Table 'sakila.actor' doesn't exist mysql> |
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 »Recently we announced MySQL Data Recovery Portal. Here we automated some data recovery routines and published web interface to them. First, it was a tool to estimate recovery chances from corrupted InnoDB tablespaces. Now it’s even more exciting and useful feature – recovery table structure from FRM files online. There are several methods to recover MySQL table […]
Continue Reading »What are odds MySQL table can be recovered? This is the most asked question. Every single customer asks if their MySQL table can be recovered. Although it’s not possible to answer that with 100% confidence there are ways to estimate recovery chances. I will describe few tricks. Generally speaking, if data is on media there […]
Continue Reading »© Copyright 2015. TwinDB LLC.
Loading...