[mythtv-users] Program information storage

Shawn Rutledge shawn.t.rutledge at gmail.com
Thu Feb 22 05:48:03 UTC 2007


On 2/21/07, Shawn Rutledge <shawn.t.rutledge at gmail.com> wrote:
> Ah, well /var/lib/mysql on my system contains a bunch of large files
> like muon-bin.0000xx with xx going from 1 to 54 currently.  I assumed
> it was actual table data in there, but maybe not...

Actually just using less to look at a file I see stuff like this (in
muon-bin.000041 for example):

@UPDATE program SET title          = 'Wicked Wicked Games',
subtitle      = '',     description    = 'Blythe Hunter goes to great
lengths to exact revenge on an
ex-lover.',     category       = '',       category_type = '',
starttime      = '2006-12-09T19:00:00', endtime       =
'2006-12-09T20:00:00',     closecaptioned = 0,        subtitled     =
0,     stereo         = 0,    hdtv          = 0,     partnu
mber     = 0,    parttotal     = 0,     airdate        = '0000',
originalairdate=NULL,     listingsource  = 1 WHERE chanid    = 2451
AND       starttime = '2006-12-09T19:00:00'

with some control characters between each SQL statement.


More information about the mythtv-users mailing list