[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