[mythtv-users] mythtv database - backup and size questions
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
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...
More information about the mythtv-users