[mythtv-users] Mythvideo listing suddenly empty

[David]

Jim Oltman wrote:

>How big does this DB-dump get?
>On Mon, 14 Mar 2005 08:17:29 -0800, Ian Forde <ian at duckland.org> wrote:
>  
>
>>On Mon, 2005-03-14 at 07:25 +0000, David Morrison wrote:
>>    
>>
>>>Obviously, I'm not doing any backups otherwise I wouldn't be grumbling
>>>so much :-)
>>>      
>>>
>>Which is why I put this little gem into a script in /etc/cron.daily:
>>    
>>
or rolling backups

12 4 * * 0 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | 
/bin/gzip > /myth/backup/mythtv_backup.sql.sun.gz
12 4 * * 1 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | 
/bin/gzip > /myth/backup/mythtv_backup.sql.mon.gz
12 4 * * 2 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | 
/bin/gzip > /myth/backup/mythtv_backup.sql.tue.gz
12 4 * * 3 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | 
/bin/gzip > /myth/backup/mythtv_backup.sql.wed.gz
12 4 * * 4 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | 
/bin/gzip > /myth/backup/mythtv_backup.sql.thu.gz
12 4 * * 5 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | 
/bin/gzip > /myth/backup/mythtv_backup.sql.fri.gz
12 4 * * 6 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | 
/bin/gzip > /myth/backup/mythtv_backup.sql.sat.gz

mine are a bit bigger than 9Mb each:

-rw-r--r--    1 root     root     54405962 Mar 11 04:13 
mythtv_backup.sql.fri.gz
-rw-r--r--    1 root     root     42468923 Mar 14 04:13 
mythtv_backup.sql.mon.gz
-rw-r--r--    1 root     root     54779342 Mar 12 04:13 
mythtv_backup.sql.sat.gz
-rw-r--r--    1 root     root     55247614 Mar 13 04:13 
mythtv_backup.sql.sun.gz
-rw-r--r--    1 root     root     54053697 Mar 10 04:13 
mythtv_backup.sql.thu.gz
-rw-r--r--    1 root     root     57641490 Mar  8 04:13 
mythtv_backup.sql.tue.gz
-rw-r--r--    1 root     root     53933510 Mar  9 04:13 
mythtv_backup.sql.wed.gz


David