[mythtv-users] And the bonehead award goes to...ME!

[Tim Tait]

Thanks-

Tim

Jamie Kinney wrote:

>To disable logging, try the following:
>
>Edit/create a file in $MYSQL_HOME/data called my.cnf and add/modify these lines:
>
>log-slow-queries = /dev/null
>log-error = /dev/null
>log = /dev/null
>
>http://dev.mysql.com/doc/mysql/en/Server_options.html
>
>-Jamie
>
>On Tue, 09 Nov 2004 13:54:38 -0500, Tim <t.tait at comcast.net> wrote:
>  
>
>>Jason Elwell wrote:
>>
>>    
>>
>>>That is almost as bad is what I did last week.  I manually ran
>>>mythfilldatabase and kept getting a bunch of 'table not found'
>>>errors.  I logged in mysql to diagnos the problem  which wasnt much
>>>help.  I figured I must have corrupted the database during a recent
>>>hard reboot.  Anyways a dropped the database and when I went to
>>>re-install a fresh copy, again I was getting errors. At about this
>>>time I realized that there was absolutely nothing wrong with my Myth
>>>database and that the reason for the errors was that the hard drive
>>>had filled up.  Boy I felt stupid and ended up losing  my entire myth
>>>database including show information for dozens of recorded programs :(
>>>
>>>Lesson learned
>>>
>>>-Jason
>>>
>>>      
>>>
>>Yeah that one had me going too.. I wish it simply returned an error that
>>said "disk is full"! Of course it was the giant MySQL log that caused
>>the problem in the 1st place. I still need to figure out how to turn
>>that off... in the meantime I just added it to the logrotate schedule.
>>
>>Tim
>>    
>>