[mythtv-users] [mythtv] MySQL database location

[Tom Dexter]

On 10/19/07, Mike Perkins <mikep at randomtraveller.org.uk> wrote:
>
> I think, to misquote some film I once saw, "these are not the log files you are
> looking for". What Mike means are what I would probably call "journals". These
> are the files that Mysql makes as it goes along so that it can fix the database
> if ever it should go titsup. On my system at least they can be found under
> /var/lib/mysql - mine are called mysql-bin.nnnnn where nnnn is a number. *Do not
> delete them*. To get rid of them, you have to make an adjustment to your Mysql
> configuration. After making the change, Mysql will clean them up on it's own.
>
> Unfortunately, I foget exactly what the needed change is, it's been a while
> since I did mine. No doubt someone with a better memory will be right along with
> the answer.
>
> Mike Perkins

I think he needs to look for:

log-bin

...in the my.cnf file and, if it's there, comment it out.

Tom