B
B
BarneyGumble2020-12-28 11:17:33
MySQL
BarneyGumble, 2020-12-28 11:17:33

Is it possible to recover data from deleted MySQL databases?

I hacked one of the old servers with Ubuntu 16.04, which I haven't monitored for a long time, deleted all the databases, I'm trying to recover at least some data from them.

There are files in /var/lib/mysql:
- ib_logfile0
- ib_logfile1
- ibdata1
- ibtmp1

1. Is it possible theoretically to get some data of remote database tables from these files?
2. Is it possible to open ibdata1 in some digestible form and manually pull out the data? Because when you open it in a text editor, it looks like this:
52az6GBFE3eELA.jpg
3. Are there any other ways to recover data from remote databases? testdisk didn't help

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
Lazy @BojackHorseman MySQL, 2020-12-28
@BarneyGumble

purely theoretically, you can run some utility for recovering deleted files and hope for a miracle.
purely theoretically, you can restore the database from the transaction log, but they are even rarer than backups.
purely theoretically, you can go into the past, make backups of databases, go back and restore data from backup.
and purely practically admins are divided into those who do not make backups and those who already do .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question