RE: FN-FORUM: MySQL retrieving lost data

date posted 1st October 2003 15:32

Jon Irvine:
> Please, please, please.... someone tell me this is possible!
>
> i just deleted (dropped) a local mysql database, is there anyway
> of getting it back?

The short answer is no.

The longer answer is maybe. MySQL stores its data in files which it deletes
when you drop the table[*]. If you've got a filesystem that will let you
undelete stuff, you may be OK. Don't know about Windows' filesystems, but
there's an ext2 howto here: http://en.tldp.org/HOWTO/Ext2fs-Undeletion.html

- Nick Grimshaw
{ if you're not part of the solution, you're part of the precipitate. }

[*] I think there's some kind of security thing you can compile in that
*really* erases the data when you drop the table by overwriting it with
zeros a few times first. But I guess you'd know if you had that compiled in.