[mythtv-users] can't upgrade db

[Tony Bones]

Hi All,
I took the plunge today and upgraded from 0.21 to 0.22.  I'm a amd64 Gentoo
user. I checked for db corruption as per the wiki and ran through the
process backing up the db, making the changes and then restoring the db.
When I run mythtv-setup it prompts me to upgrade the db, which I do and then
it simply closes.  I ran with -v database so you could see below.

Any ideas?  I have no myth ATM :(

2010-04-27 19:44:05.706 Database Backup complete.
> 2010-04-27 19:44:05.720 Backed up database to file:
> '/mnt/store/mythconverg-1215-20100427194342.sql.gz'
> 2010-04-27 19:44:05.722 MSqlQuery::exec() "DELETE FROM settings WHERE value
> = 'BackupDBLastRunEnd' AND hostname is NULL;"
> 2010-04-27 19:44:05.722 MSqlQuery::exec() "INSERT INTO settings (value,data
> ) VALUES ( 'BackupDBLastRunEnd', '2010-04-27 19:44:05' );"
> 2010-04-27 19:44:05.723 Clearing Settings Cache.
> 2010-04-27 19:44:05.723 Clearing Settings Cache.
> 2010-04-27 19:44:05.724 MSqlQuery::exec() "DELETE FROM housekeeping WHERE
> tag = 'BackupDB' ;"
> 2010-04-27 19:44:05.725 MSqlQuery::exec() "INSERT INTO
> housekeeping(tag,lastrun) values('BackupDB' ,now()) ;"
> 2010-04-27 19:44:05.837 MSqlQuery::exec() "SELECT data FROM settings WHERE
> value = 'DBMSVersionOverride' AND hostname = 'walter' ;"
> 2010-04-27 19:44:05.838 MSqlQuery::exec() "SELECT data FROM settings WHERE
> value = 'DBMSVersionOverride' AND hostname IS NULL;"
> 2010-04-27 19:44:05.839 MSqlQuery::exec() "SELECT VERSION();"
> 2010-04-27 19:44:21.693 MSqlQuery::exec("ALTER DATABASE mythconverg DEFAULT
> CHARACTER SET utf8 COLLATE utf8_general_ci;")
> 2010-04-27 19:44:21.694 Newest MythTV Schema Version : 1244
> 2010-04-27 19:44:21.694 MSqlQuery::exec("CREATE TABLE IF NOT EXISTS
> schemalock ( schemalock int(1));")
> 2010-04-27 19:44:21.695 MSqlQuery::exec("LOCK TABLE schemalock WRITE;")
> 2010-04-27 19:44:21.696 MSqlQuery::exec() "SELECT data FROM settings WHERE
> value = 'DBSchemaVer' AND hostname = 'walter' ;"
> 2010-04-27 19:44:21.698 MSqlQuery::exec() "SELECT data FROM settings WHERE
> value = 'DBSchemaVer' AND hostname IS NULL;"
> 2010-04-27 19:44:21.698 MSqlQuery::exec("SHOW FULL TABLES")
> 2010-04-27 19:44:21.701 MSqlQuery::exec("CREATE TEMPORARY TABLE temp_people
> SELECT * FROM people;")
> 2010-04-27 19:44:22.014 MSqlQuery::exec("ALTER TABLE temp_people  MODIFY
> name VARBINARY(255)    NOT NULL default '';")
> 2010-04-27 19:44:22.267 MSqlQuery::exec("ALTER TABLE temp_people  MODIFY
> name CHAR(255)           CHARACTER SET utf8            COLLATE utf8_bin
> NOT NULL default '';")
> 2010-04-27 19:44:23.411 MSqlQuery::exec("SHOW COUNT(*) WARNINGS;")
> 2010-04-27 19:44:23.412 Database corruption detected. Unable to proceed
> with database upgrade. (Table: people, Warnings: 1481)
> 2010-04-27 19:44:23.412 Your database must be fixed before you can upgrade
> beyond 0.21-fixes. Please see
> http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding for
> information on fixing your database.
> 2010-04-27 19:44:23.412 Database Schema upgrade FAILED, unlocking.
> 2010-04-27 19:44:23.413 MSqlQuery::exec("UNLOCK TABLES;")
> 2010-04-27 19:44:23.413 Enabling Settings Cache.
> 2010-04-27 19:44:23.413 Clearing Settings Cache.
> 2010-04-27 19:44:23.413 Couldn't upgrade database to new schema.
>

Thanks,
Tony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100427/61409cb7/attachment.htm>