[mythtv] Database integrity

[Timon, John]

further to this question is there any value in having a cron job dump out
the schema+data of the myth database on a regular basis?

--
John Timon
Desk: 519 667 7187
Cell: 519 852 0042
Email: john.timon at labatt.com
Pager: 519 430 1826
Unix like TeePee no windows, no gates, Apache inside.


-----Original Message-----
From: Aaron Longson [mailto:zenoniii at yahoo.com] 
Sent: Wednesday, January 07, 2004 1:32 PM
To: mythtv-dev at mythtv.org
Subject: [mythtv] Database integrity


     After having my system crash, I ran into a slight problem I don't think
has been accounted for.  As a result of my crash(and subsequent frontend
crashes), my database was corrupted.  I was able to fix the tables using
"myisamchk", but the data in the tables is still not quite up to snuff.
     This leads to the my question:  Is there a script or utility to restore
data integrity of the mythconverg tables?  For instance, verify that
programs in the "recorded" table actually exist.  If the utility doesn't
exist, could someone create the utility or send me a description of table
relationships and their use in mythtv so I could create it.


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus