mysql doesn't support anything called rollback upto 4.0 Nitin
----- Original Message ----- From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "debug" <[EMAIL PROTECTED]> Sent: Wednesday, October 15, 2003 8:37 PM Subject: Re: assorted: foreign keys, mult databases, and crashes > * DeBug > > >> How does one restore a mysql database if it crashes in > > >> the middle of a large operation? > > > > RB> Not sure what you mean... > > > > What if i on purpose turn off the computer when mysql is in the middle of > > transaction execution ? > > Then someone should smack your fingers...! ;) > > > Will the server on restart automatically > > rollback the crashed transaction ? > > If you are lucky. I really don't know, but I would expect a database server > to try to keep the data consistent, ie rollback crashed transactions. > However, I would not rely on that allways succeeding. Having a backup is > allways a good idea. > > -- > Roger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]