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

[David Campbell]

Steven Adeff wrote:
>>> #!/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...

It is true  - Debian does use INNODB by default.  Not a good thing IMVHO.

MYISAM = Fast, non ACID complaint, less features - will run MYTH fine
INNODB = Slow, ACID complaint, more features

Changing engine isn't for the MYSQL newcomer but it is very trivial - 
see the ALTER TABLE pages of the MYSQL documentation

I won't post the exact syntax for fear of people cutting and pasting my 
commands

Dave