Re: [PHP-WIN] mysql rollback

2004-05-26 Thread Sudeep Zamudra
Could u just give me what should be the statement to rollback a database for eg "abc" [EMAIL PROTECTED] wrote:what verion of mysql do you have? Early version of MySQL didn't include the rollback functionality. Do you not have any mysql_dumps of the databases and/or tables? (Its vital that you ba

Re: [PHP-WIN] mysql rollback

2004-05-26 Thread Svensson, B.A.T. (HKG)
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 t

[PHP-WIN] mysql rollback

2004-05-26 Thread Sudeep Zamudra
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.