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 backups) and the update log (a good idea to have)
to restore a recent, consistent state.
Bye,
Benjamin.
PS: Btw, transactions are not a mean to guard against crash
inconsistencies. If MySQL crashes, you encountered some software
failure and, although improbable, it could very well have erased
your data file beforehand.
PPS: Removed the internals list from CC because this is not about
writing MySQL code, is it?
On Sun 2002-06-02 at 16:39:36 -0500, [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 of the statement would get executed before
> the crash while the rest is not?
> Would you please direct me to where i can find documentation about how MySQL
> handles recovery in case of normal queries (one sql statement) not
> transactions (as i know it uses journals for transactions, but not sure if
> it does the same with queries)
>
> Thanks,
> Khaled
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
