Hi,
I have a table with a primary key defined with the auto_increment
option.
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.
Bye
"Hamvil"
news:1137684558.139613.97960@o13g2000cwo.googlegroups.com...
> I've incidentally deleted some rows from this table and I would like to
> know if it is possible to recover that data.
In general, no. There is no "undelete" statement.
> It is still lying around in the mysql files?
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:
http://answers.google.com/answers/threadview?id=528848
Regards,
Bill K.