[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:
100
Number of episodes:
543
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:
6%
_______________________________________________
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