[mythtv-users] How to: Recover 2GB from /var/log/mysql (Ubuntu, Mysql)
adeffs.mythtv at gmail.com
Fri Mar 23 19:33:01 UTC 2007
On 3/23/07, David Campbell <dave at cpfc.org> wrote:
> 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
Thanks, I'll have to look into this.
Perhaps it should be noted on the wiki for those setting up new
databases that they should make sure they are set to use MYISAM?
Before you ask, read the FAQ!
then search the Wiki, and this list,
Mailinglist etiquette -
More information about the mythtv-users