<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>I didn't find much information on the list, so here I am asking. Please excuse if its a dupe.<br><br>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.<br><br>So, I have two questions:<br><br>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.<br><br>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?<br><br>Thanks a lot for your patience and help! Happy New Year!<br>-devsk</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>