[mythtv-users] How big is your database?
greg at phaze.org
Wed Nov 30 23:41:34 EST 2005
> guessing that deleting a recording will correctly flush everything
> else associated with it (cutlist, mythcomflagging, etc), but does the
Yes, those get removed.
> DB keep any records of -everything- I've ever recorded, and will those
Yes, an entry goes into oldrecorded with information about the show.
So this will grow "forever" but the per show data is pretty miniscule.
> And if I do mysqldump, is that likely to be enormous? (I'm guessing
My SQL data of a myth database that has been running for ~2.5 years
is around 120Meg for the binary data files, 108Meg for the SQL dump, and
the SQL dump is 12Meg gzipped.
More information about the mythtv-users