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.
Recover deleted Records.
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.
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.
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.
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.
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.