[mythtv-users] How to: Recover 2GB from /var/log/mysql (Ubuntu, Mysql)
dave at cpfc.org
Fri Mar 23 14:53:58 UTC 2007
Steven Adeff wrote:
> I encountered this problem over last weekend, these logs filled my
> drive and caused some serious headache.
> I discovered this operative in the MySQL my.cnf file,
> expire_logs_days = 2
> which supposedly removes logs older than the number of days you
> specify, and so far this looks to be working on my machine.
> I also have a cron job that runs nightly,
> #Dumps the mythconverg database - daily backup
> #Keeps the last 7 days
> DAY=($(date +%u))
> mysqldump -u mythtv -pmythtv mythconverg -c > /MythTV/tv/MYSQL/Backup/$DUMPFILE
> exit 0
> which dumps from my main C drive to my RAID recording drive.
I'd use mysqldump --opt
But then again - I wouldn't use INNODB ever.
More information about the mythtv-users