[mythtv-users] [mythtv] MySQL database location

[James Fidell]

Mike Perkins 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.

Those sound like the replication logs for mysql slaves to me, enabled by
"log-bin" in my.cnf.

If innodb is enabled, that writes some "logfiles", but I don't recall
them taking up significant amounts of disk space.  If innodb is enabled,
it can be turned off in my.cnf using "skip-innodb", IIRC.

James