Re: mysql rollback
| From: | HKG) | Date: | Wed, 26 May 2004 14:40:17 +0000 |
| Subject: | Re: mysql rollback | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23844@lists.php.net to get a copy of this message | ||
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