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

devsk funtoos at yahoo.com
Mon Jan 1 19:03:53 UTC 2007

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,

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


BTW here is my cron job:

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

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

mythtv-users mailing list
mythtv-users at mythtv.org

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

More information about the mythtv-users mailing list