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 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 > Hi! It depends on the table handler. With MyISAM you have to REPAIR TABLE(s) thereafter if they are corrupted. But why would MySQL server crash at all , when it is very stable. Also, keep in mind that this list is dedicated to the internal functioning of MySQL server, not to the general questions of this kind. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- 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
