Hi<br><br><div class="gmail_quote">2009/3/12 Nick Morrott <span dir="ltr"><<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Have you got a lot of current recordings? A good chunk of that 200MiB<br>
could be the recordedseek information for those recordings. It is<br>
possible (although not through normal operation) for recordedseek data<br>
to linger even after the recording has been deleted.<br>
</blockquote><div><br>1.2TB worth ... I keep the original MPEG2 (from DVB-T) file.<br><br>Though I could use transcode, but transcode always gave me errors and never ever completed.<br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
On my current system, I have 100GB of recordings (~50hrs) in MPEG-2<br>
format, and the associated recordedseek data is taking up 36MiB with a<br>
10MiB overhead. This represents about 45% of the total database size.<br>
<br>
Another sizeable chunk could be the program listings data for your<br>
configured channels.<br>
<br>
You can check your /var/lib/mysql/mythconverg directory and list by<br>
filesize to see which tables in the DB are taking up the most space.<br>
IMO it is unlikely (although not impossible) that you will have many<br>
MiB of associated cruft in other places in the database.<br>
<br>
</blockquote><div><br>Well, I don't care much about the size of the database ... More like I would like to start as if it was a brand new mythtv installation, without any of the old settings that came from 0.18 and got dragged through.<br>
<br>Like for the imdb scripts.<br>on my system I have to fill three fields . On a new 0.21, there's only one required <br></div></div><br>I've been enjoying your backup scripts BTW ... I still have an error here and there where it doesn't automatically find the latest backup name , and I have to specify it on the command line.<br>
<br>Jean-Yves<br><br>