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 --------------------------------------------------------------------- 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
