[mythtv-users] Anyway to export stats from Mythtv db

Marc drayson at net1plus.com
Mon May 12 11:51:07 UTC 2008

Thanks for pointing me in the right direction, I just ran a mysqldump
-umythtv -p mythconverg oldrecorded > oldrecorded.sql

then removed the DROP TABLES and CREATE TABLE statements so it just
inserted the old data into the current table.

all looks good, now have my old stats :)

Number of shows:
Number of episodes:
First recording:
    Monday August 13th, 2007
Last recording:
    Monday May 12th, 2008
Total Running Time:
    8 months 29 days 12 hrs 42 mins
Total Recorded:
    18 days 4 hrs 43 mins
Percent of time spent recording:


Not a problem Tony

Now catch up.
Number of shows: 90 
Number of episodes: 1367 
First recording: Thursday December 28th, 2006 
Last recording: Friday May 9th, 2008 
Total Running Time: 1 year 4 months 11 days 19 hrs 15 mins 
Total Recorded: 1 month 20 days 11 hrs 42 mins 
Percent of time spent recording: 10%

More information about the mythtv-users mailing list