[gentoo-user] mysql database getting too big

The mysql database used only by mythtv has grown to 1.3Gbytes - a bit over the top! mythconverg itself is only 34Mbytes, but /var/lib/mysql is full of files named (myth1 is the hostname): myth1-bin.01 myth1-bin.02 myth1-bin.03 ... basicly one for each day operations occur on the

Re: [gentoo-user] mysql database getting too big

mythconverg itself is only 34Mbytes, but /var/lib/mysql is full of files named (myth1 is the hostname): myth1-bin.01 myth1-bin.02 myth1-bin.03 ... basicly one for each day operations occur on the database. Can they be safely deleted/compressed or reduced in size somehow? I have

Re: [gentoo-user] mysql database getting too big

Thank you, just what I needed. I thought I had turned binary logging off, and didnt expect to find the files there in any case. BillK On Sun, 2006-06-18 at 11:50 +0400, Alexander Kirillov wrote: PURGE MASTER LOGS TO 'myth1-bin. -- gentoo-user@gentoo.org mailing list