<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"> never mind!!<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: devsk <funtoos@yahoo.com><br>To: Discussion about mythtv <mythtv-users@mythtv.org><br>Sent: Monday, January 1, 2007 11:03:53 AM<br>Subject: Re: [mythtv-users] mythtv database - backup and size questions<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">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.<br><br>Thanks a
bunch,<br>-devsk<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: John Drescher <drescherjm@gmail.com><br>To: Discussion about mythtv <mythtv-users@mythtv.org><br>Sent: Monday, January 1, 2007 10:37:23 AM<br>Subject: Re: [mythtv-users] mythtv database - backup and size questions<br><br><div>On 1/1/07, devsk <funtoos@yahoo.com> wrote:<br>><br>> I didn't find much information on the list, so here I am asking. Please<br>> excuse if its a
dupe.<br>><br>> I was trying to see how to best backup my mythtv setup and current database<br>> like recorded shows, cutlists etc. I did a 'mysqldump -u mythtv -pmythtv<br>> mythconverg -c > mythtv_backup.sql' and noticed that the file was just<br>> 17MBytes, whereas 'du -sk /var/lib/mysql' returned 470MBytes.<br>><br>> So, I have two questions:<br>><br>> 1. Is 'mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql' a<br>> complete backup for a myth setup? I plan to do this everyday in a cron job<br>> and keep it with the other complete install backup which I do whenever I do<br>> major upgrades.<br>><br>This is what I do.<br><br>><br>> 2. What are those <hostname-bin.xxxx> files in /var/lib/mysql and why is<br>> that dir so huge compared to the database size? Is that preallocated<br>> database files? Is that the directory I should be backing up?<br>><br>I believe these are not needed.<br><br><a
rel="nofollow" target="_blank" href="http://dev.mysql.com/doc/refman/5.0/en/binary-log.html">http://dev.mysql.com/doc/refman/5.0/en/binary-log.html</a><br><br>BTW here is my cron job:<br><br># cat /etc/cron.daily/mythbackup.cron<br><br>#!/bin/sh<br>date=`date -I`<br>mysqldump mythconverg | bzip2 -c > /var/backup/backup-$date.sql.bz2<br><br>John<br>_______________________________________________<br>mythtv-users mailing list<br>mythtv-users@mythtv.org<br><a rel="nofollow" target="_blank" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></div></div><br></div></div><br>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br><span><a target="_blank" href="http://mail.yahoo.com">http://mail.yahoo.com</a> </span><div>_______________________________________________<br>mythtv-users mailing
list<br>mythtv-users@mythtv.org<br><a target="_blank" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></div></div><br></div></div><br>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com </body></html>