[mythtv-users] MySQL Database Overflow

[Nick Morrott]

On 12 Oct 2008 04:05:27 +0000, Nathan Lanchbury <mythtv at lanchbury.id.au> wrote:

>  I have seen this problem once before and it turned out my database was corrupt (when exported over 500MBs) so I was able to strip out what was needed and import it back. Then learnt it was wise to back it up. So I created a nightly replaced backup and a weekly stored backup.
>
>  So everything shows to me the same thing has happened. BUT stripping the data doesn't work. The last night backup doesn't help along with the week backup, as is or stripped to just the recorded and scheduled recordings.

Have you run the optimize_mythdb.pl script on the database?

Do you see any errors in the mythbackend logfile?

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin