[mythtv-users] How to: Recover 2GB from /var/log/mysql (Ubuntu, Mysql)
dave at cpfc.org
Fri Mar 23 15:15:43 UTC 2007
Steven Adeff wrote:
>>> #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.
> 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
More information about the mythtv-users