showmetech.com.br

How to Handle Database Errors in MySQL

MySQL databases are used by many content management systems (CMS) to support websites. Given the possibility that they can be accessed directly through the web interface, they can also be more ...
Linux Journal

Recover a MySQL Table with Zmanda Recovery Manager

If somebody accidentally drops a critical table in MySQL, the application no longer works. The solution to this problem is to utilize the (open source) Zmanda Recovery Manager. You are a MySQL ...
GitHub

db-recovery is a tool for recovering MySQL data. It is used in scenarios where the database has no backup or binlog. It can parse data files and redo/undo logs to recover data.

Parse the contents of the recycle bin（PAGE_FREE） in the index page in the MySQL InnoDB data file, and generate the corresponding replace into statement.The index page is only the stored column data, ...
GitHub

mysql_recover-_tables_from_ibd_format

then create old table for example this CREATE TABLE IF NOT EXISTS sms(id INTEGER PRIMARY KEY, status text CHARACTER SET utf8mb4, sender TEXT, receiver TEXT , date_time timestamp,status TEXT,extra TEXT ...