[mythtv-users] DB tables corrupt, need advice on fixing

[Michael T. Dean]

On 10/25/2015 12:03 AM, Hika van den Hoven wrote:
> If you have access to phpmyadmin you can rename the old database
> before restoring then drop the damaged tables and copy the restored
> tables in place. Then drop the restored database and rename the
> original back.

Though doing so will leave you with broken data, where some of the data 
in the restored-from-backup tables referenced by the "copied over" 
tables does not exist.  In other words, the problem with this approach 
is that you'll have new data in some tables and 2(or more)-day-old data 
in other tables, so some tables will be lacking their data from the last 
couple days.  How much of an effect this will have on MythTV as a whole 
(and how much breakage it will cause, not to mention when that breakage 
will become visible, as it may not be noticed for days/months/...)--and 
whether you're willing to live with that breakage--is the question.

So, basically, mixing data from different times will break your 
inter-entity (cross-table) data integrity (and the tables you mentioned 
do have cross-table relationships).

Mike