Re: assorted: foreign keys, mult databases, and crashes

[Roger Baklund]

* 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