How did you lose them? I don't know about mySQL, but in general DELETE, INSERT and UPDATE are logged while DROP and TRUNCATE are not. If you do /not/ use auto commit /and/ did /not/ do commit, then you can use rollback to undo a delete/insert/update. Else you need to restore the database from the last backup. On Wed, 2004-05-26 at 16:34, Sudeep Zamudra wrote: > Help please, > > i lost all of my database tables all of a sudden. It was in for example > a database called "abc". Can i retrieve the entile table and it's > comtents by any means. Thru any Rollback statement. Help please > > > > > --------------------------------- > Do you Yahoo!? > Friends. Fun. Try the all-new Yahoo! Messenger -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
