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

Jamie Kinney oracledude at gmail.com
Tue Nov 9 21:20:25 UTC 2004


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
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


More information about the mythtv-users mailing list