[mythtv-users] error when fixing database forced by mythtv upgrade

[Michael T. Dean]

On 10/16/2009 03:48 AM, Gary Dawes wrote:
> I have also been hit by the corruption issue, when trying to go to 
> 0.22 RC1, currently running 0.21 with a database schema bversion 1215. 
> I have been though the wiki article on how to repair the database 
> several times now this morning, and have followed the various 
> instructions by Mike to no avail.
>
> the error I get (with verbose on) is
>
> 'mysql' --defaults-extra-file='/tmp/wPMWZ7oQgH' --host='localhost' 
> --user='mythtv' 'mythconverg'
> ERROR 1062 (23000) at line 1915: Duplicate entry 
> 'JÃÂÃâ¬Ã»ÃÂÃâ¬Ã»rÃÂÃâ¬Ã»' for key 2
>
> I have searched for this string in phpmyadmin, and also ran a grep 
> against the initial backup and the repaired file and cannot find the 
> string. Advice on how to track this and fix would be appreciated.

This means you have partial corruption, not total corruption.  That 
means that each individual record in your DB needs fixing--and then all 
the duplicates handled in such a way that all the foreign references are 
properly updated.

I'm working on a way to do this, but I'm not done.

Mike