[mythtv-users] Mythconverg_restore corrupted my database?

[Stephen Bridges]

Hi all,

I've got a database problem I'm hoping you can shed light on.  It revolves 
around a failed 0.23 upgrade.  Right now I don't care why the upgrade failed, 
but mythfrontend segfaults instead of playing video.  I will provide 
backtraces some other time.

I'm running 0.22-fixes (r24255) on a Gentoo machine that's running the proper 
utf8 mysql database.  I partial restored to upgrade from 0.21 to 0.22 so 
that's all sorted.

I take backups nightly of the db and I performed the upgrade on Monday which 
took another one.  As I've said 0.23 (r23069) didn't work so I dropped the 
database and restored the backup.   I had another go today, with an upgraded 
and rebuilt Qt (4.6.3) and it still didn't work, so I dropped and tried to 
restore.

All the backups taken since my failed upgrade on Monday will not restore due 
to duplicate keys of foreign names such as "ERROR 1062 (23000) at line 1667: 
Duplicate entry 'Zin?dine Zidane' for key 2".  The dumps all have two entries 
for Zinadine Zidane now, as opposed to the dump from Monday which did not.

I can restore Monday's backup and lose DB changes since Monday, but all the 
duplicate entries will presumably return, and all backups taken will be 
corrupt and therefore useless.

Appended are the database re-creation script I used and the status of the 
failed restore.

Help!

Widget.

--
CREATE DATABASE IF NOT EXISTS mythconverg;
GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost IDENTIFIED 
BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

--
Connection id:          225700
Current database:       mythconverg
Current user:           mythtv at localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.90 Gentoo Linux mysql-5.0.90-r2
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 42 days 6 hours 22 min 4 sec