It think MySQL could very well have corrupted the data back in 3.23.38 for Marian
when I first started out using mysql, I was fairly new to linux and totally new to MySQL MySQL default install went to /var/lib/mysql, default RedHat /var is quite small So unknowingly to me, it filled up quite quickly, and MySQL did indeed keep on chugging, and my data did indeed get totally trashed Since no other daemons were running that would write to /var (not even mail) then my finger was pointing at mysql I was also running replication at the time, so that may have also been a problem, mind you I was able to succesfully restore from the slave datasets ( i believe it did not send any more updates to the slave once the filesystem was full ) dunno, just an experience I had to share > -----Original Message----- > From: Mark Matthews [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 02, 2002 10:22 AM > To: Nairam > Cc: [EMAIL PROTECTED] > Subject: Re: Bug ? > > > Marian wrote: > > Why mysql corrupt tables if filesystem if full ... ? > > > > On good database servers (eg. PROGRESS) process shutdown server > > (protetcting data). > > > > sytem: > > linux-2.2.19 > > mysql-3.23-38 > > > > > > > --------------------------------------------------------------------- > > 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 > > > > What table types are you using? MySQL doesn't usually corrupt tables > when the disk is full, it handles it in the following way: > > http://www.mysql.com/doc/en/Full_disk.html > > Also, you're using a pretty old version of MySQL, you might want to > upgrade to a newer version if possible. The latest version in > the 3.23 > series is 3.23.52 > > -- > For technical support contracts, visit > https://order.mysql.com/?ref=mmma > > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer > - JDBC/Java > /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA > <___/ 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
