[mythtv-users] How to: Recover 2GB from /var/log/mysql (Ubuntu, Mysql)
adeffs.mythtv at gmail.com
Fri Mar 23 15:01:03 UTC 2007
On 3/23/07, David Campbell <dave at cpfc.org> wrote:
> 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,
> > #!/bin/sh
> > #Dumps the mythconverg database - daily backup
> > #Keeps the last 7 days
> > DAY=($(date +%u))
> > DUMPFILE="mythbe_"$DAY".sql"
> > 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.
This is how mysql came setup on the Debian based system I use. I don't
really no the difference between INNODB and MYISAM or what it takes to
switch between the two...
Before you ask, read the FAQ!
then search the Wiki, and this list,
Mailinglist etiquette -
More information about the mythtv-users