[mythtv-users] mythtv database - backup and size questions

devsk funtoos at yahoo.com
Mon Jan 1 19:42:59 UTC 2007


 never mind!!

----- Original Message ----
From: devsk <funtoos at yahoo.com>
To: Discussion about mythtv <mythtv-users at mythtv.org>
Sent: Monday, January 1, 2007 11:03:53 AM
Subject: Re: [mythtv-users] mythtv database - backup and size questions

do you know how do I grant user 'mythtv' the 'reload' privilege so that I can delete those 460MB of logs before my next backup of the install? I don't which user has that privilege.

Thanks a bunch,
-devsk

----- Original Message ----
From: John Drescher <drescherjm at gmail.com>
To: Discussion about mythtv <mythtv-users at mythtv.org>
Sent: Monday, January 1, 2007 10:37:23 AM
Subject: Re: [mythtv-users] mythtv database - backup and size questions

On 1/1/07, devsk <funtoos at yahoo.com> wrote:
>
> I didn't find much information on the list, so here I am asking. Please
> excuse if its a
 dupe.
>
> I was trying to see how to best backup my mythtv setup and current database
> like recorded shows, cutlists etc. I did a 'mysqldump -u mythtv -pmythtv
> mythconverg -c > mythtv_backup.sql' and noticed that the file was just
> 17MBytes, whereas 'du -sk /var/lib/mysql' returned 470MBytes.
>
> So, I have two questions:
>
> 1. Is 'mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql' a
> complete backup for a myth setup? I plan to do this everyday in a cron job
> and keep it with the other complete install backup which I do whenever I do
> major upgrades.
>
This is what I do.

>
> 2. What are those <hostname-bin.xxxx> files in /var/lib/mysql and why is
> that dir so huge compared to the database size? Is that preallocated
> database files? Is that the directory I should be backing up?
>
I believe these are not needed.

http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

BTW here is my cron job:

# cat /etc/cron.daily/mythbackup.cron

#!/bin/sh
date=`date -I`
mysqldump mythconverg | bzip2 -c  > /var/backup/backup-$date.sql.bz2

John
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users






__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com _______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users






__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070101/74dcd751/attachment.htm 


More information about the mythtv-users mailing list