Recovering deleted rows

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have a table with a primary key defined with the auto_increment

I've incidentally deleted some rows from this table and I would like to
know if it is possible to recover that data. It is still lying around
in the mysql files?

Many thank for any information.


Re: Recovering deleted rows

Quoted text here. Click to load it

In general, no.  There is no "undelete" statement.

Quoted text here. Click to load it

Maybe in some fragmentary form, but deleted data are likely to be
overwritten by subsequent database activity.

Here's a page that gives a couple of other tips:

Bill K.

Site Timeline