the deleted rows will get re-used by inserts. however, you can always run OPTIMIZE TABLE XXX and that will clear the deleted rows
thanks, -- Andrew ----- Original Message ----- From: "Steve Wright" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 19, 2001 12:03 PM Subject: undelete records ? > > I've had a dig around the mysql website / google & can't find an answer so > maybe someone here can help... > > we've noticed data/records deleted from mysql databases still appear to exist > in the /var/lib/mysql/database/ files ? > > I presume they are flagged for deletion at a later date, if this is true can > anyone tell me when they are really deleted and if until then they can be > recovered? > > A point in the right direction / website would be great. > > Thanks > Steve. > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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