On Sun, 2 Jun 2002 16:39:36 -0500
"Khaled Elmeleegy" <[EMAIL PROTECTED]> wrote:
> What if the MySQL server crashes during an Insert or delete or update
> statement, In what state would that leave the database, and would MySQL
> recover? If so how would it do that?
> If not what would happen, half
Hi.
With MyISAM the table will be marked crashed and you have to repair it
(with myisamchk or REPAIR TABLE). In most cases this will simply
disregard the last change. There is a low probability that the table
is broken in a more serious way and you have to use your last backup
(you surely do make
What if the MySQL server crashes during an Insert or delete or update
statement, In what state would that leave the database, and would MySQL
recover? If so how would it do that?
If not what would happen, half of the statement would get executed before
the crash while the rest is not?
Would you pl