Hello.
On Wed 2002-12-18 at 14:49:12 +0000, [EMAIL PROTECTED] wrote:
> Hi,
>
> I posted this a few days ago, but haven't seen a reply as yet, and I'm
> getting quite desperate now!!
You probably got no reply because there is no real solution to your
problem.
> I've managed to delete all the records in a table, well haven't we all done
> it sometime!, and was wondering whether it's possible to recover
> them. I notice that the .MYD and .MYI files still appear to be showing the
> original data.
You are right, the data is still there (some data is lost, if dynamic
row storage is used). But there is no tool ready to recover the data.
You are expected to have backups. Recovering the data "by hand" will
be a *lot* of work.
Before doing anything else, make sure to create a backup of the files,
in case anything else goes wrong.
If you need the data desperately enough to invest in the recovering,
you may want to consider contacting the MySQL people directly and ask
if they are able to help.
If you have update-logs enabled, you could re-run the queries to
recreate the tables.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
