Recover deleted Records.

marsheng's profile image marsheng posted 10 years ago in General Permalink
I was busy writing my app in Delphi and testing the delete records while debugging. I have a daily backup of my computer, so I thought I would just recover the data when finished, that was till I realized that the MYSQL DB was not included in the backup.

Any way to recover records. - No work has been done on the DB since the deletions.

Thanks Wallace.
jfalch's profile image jfalch posted 10 years ago Permalink
cf. http://stackoverflow.com/questions/6924823/how-to-recover-just-deleted-rows-in-mysql - in short: generally not possible unless you happen to use innodb.
marsheng's profile image marsheng posted 10 years ago Permalink
Thanks for the reply.

I did download innodb but I ended up with a whole lot of c files. I could not find out how to run it.

Is there an windows exe somewhere?

Thanks Wallace
kalvaro's profile image kalvaro posted 10 years ago Permalink
You... you downloaded InnoDB??

InnoDB is an option you select when you create a table:


marsheng's profile image marsheng posted 10 years ago Permalink
I'm learning all the time. I thought InnoDB was an app. This is what I looked at

https://launchpadlibrarian.net/78359944/percona-data-recovery-tool-for-innodb-0.5.tar.gz

It is full of c code.

It looks like the default for MYSQL is InnoDB, so I'm part the way there.

The data is not too important but the exercise is very worth while doing. Just in case it happens with important data.


Ps my MYSQL DB is running off a raspberry PI. Very slow with the terminal and PHPMYAdmin to work on it, but accessing the data with my Delphi program is lightening fast. Very impressed. Running off an 8GB flash disk.



jfalch's profile image jfalch posted 10 years ago Permalink
you get the tool in source code format, which means you have to compile it yourself; no mean feat. i do not know the raspi, so i dont know wether a compiler is already installed (try typing the command gcc to the shell and observe what happens); if not, you´ll have to install packages for gcc and make, probably more, at least the mysql-dev package conatining the mysql server header files.
when all packages are installed, you should be able to cd into the tools´ dir and type the command make, this should start the compile and deliver 1+ excutable. if it doesn´t, good luck and happy googling.

Please login to leave a reply, or register at first.