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

[Nitin]

mysql doesn't support anything called rollback upto 4.0

Nitin

----- Original Message ----- 
From: "Roger Baklund" <roger@stripped>
To: <mysql@stripped>
Cc: "debug" <debug@stripped>
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/mysql?unsub=1
>