[mythtv-users] Mythconverg_restore corrupted my database?
widget at stdin.co.uk
Fri Jun 18 17:47:27 UTC 2010
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
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
CREATE DATABASE IF NOT EXISTS mythconverg;
GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost IDENTIFIED
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
More information about the mythtv-users