Do you have update logging on? This would be true if you started up mysql with
--log-update in the command line. You can check the "log_update" variable to see if it is
on.
If you do have update logging on, then you'll have all the DML stuff (insert, update,
delete) in your datadirectory (or wherever you specified the logs will be) and you might
be able to re-create some data from there.
the default filename for the update logs is $HOSTNAME.XXX, i.e. myhost.001, myhost.002,
etc.
good luck....I've been there...
-Don
-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard@stripped]
Sent: Wednesday, May 08, 2002 9:36 AM
To: mysql@stripped
Subject: RE: Undelete??
[snip]
Is it possible to undelete records if you delete all records from a MySQL
table accidentally?
[/snip]
Got backup?
Jay
---------------------------------------------------------------------
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 <mysql-thread108342@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-dvu=madstonefilms.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
