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

Steven Adeff 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
> commands
>
> Dave

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?

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


More information about the mythtv-users mailing list