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

[Petr Stehlik]

Petr Stehlik píše v Ne 27. 09. 2009 v 12:58 +0200:
> Petr Stehlik píše v Ne 27. 09. 2009 v 11:39 +0200:
> 
> > /home/joy/myth/22/share/mythtv/mythconverg_restore.pl --filename mythconverg-to_uncorrupt.sql --directory /var/tmp
> > ERROR 1062 (23000) at line 1700: Duplicate entry 'Samuel Ivaška (Slovenská republika' for key 2
> 
> BTW, the SELECT * FROM mythconverg.people where name like "Samuel Iva%"
> looks as follows:
> 
> "person","name"
> 2871,"Samuel Ivaška (Slovenská republika 1983)"
> 4094,"Samuel Ivaška (Slovenská republika 1988)"
> 644,"Samuel Ivaška Hrají: Vladimír Hajdu"
> 3686,"Samuel Ivaška. Hrají: Ferdinand Libant"
> 37451,"Samuel Ivaška. Hrají: Ján Havrila. (Slovenská republika
> 1988)"
> 
> I cannot see any duplicate entry there.

I went ahead and deleted the two lines in the SQL dump that INSERT INTO
people to get rid of the non-existing duplicates. Now I am getting the
following error that makes even less sense than the "duplicates":

$ /usr/local/myth/share/mythtv/mythconverg_restore.pl
--directory /var/tmp --filename mythconverg-to_uncorrupt.sql 

ERROR: The database does not exist.

I have made sure many times that mythconverg database does exist. Could
sphery help me out, please?

Petr