[mythtv-users] How to: Recover 2GB from /var/log/mysql (Ubuntu, Mysql)

[Steven Adeff]

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

-- 
Steve
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette