* 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]