[mythtvnz] Corrupt database?

Paulgir paulgir at gmail.com
Wed Jan 23 07:35:22 GMT 2013


When I checked Mythtv (Mythbuntu)today I found it showing a language set  
up window that I had not seen before.I closed this window and was on the  
xfce desktop,I tried to start Myth frontend or mythbackend setup it  
reverts to the language set-up window.
I tried to do a database restore but I get this message:

Database Information:
          DBHostName: localhost
              DBPort: 3306
          DBUserName: mythtv
          DBPassword: XXX
              DBName: mythconverg
         DBSchemaVer:
   DBBackupDirectory: /var/lib/mythtv/db_backups
    DBBackupFilename: mythconverg-1299-20130122184502.sql.gz
       drop_database: no
     create_database: no

Executables:
        mysql_client: mysql
          uncompress: gzip -d

Miscellaneous:
     partial_restore: no
    restore_xmltvids: no
     change_hostname: no

Checking database.

Found 105 tables in the database.
WARNING: Database not empty.

ERROR: Unable to do a full restore. The database contains data





So what am I doing wrong - any suggestions?

The reason I tried to do a db restore was because I got some error  
messages when I tried myth_fill_database:







This version of MythTV requires an updated database. (schema is 1299  
versions behind)

Please run mythtv-setup or mythbackend to update your database.

Database Host: localhost
Database Name: mythconverg

2013-01-23 19:49:17.500860 C  ERROR: Unable to acquire database upgrade  
lock
2013-01-23 19:49:17.500869 C  Waiting for Database Upgrade to complete.
2013-01-23 19:49:17.500880 C  Timed out waiting.
2013-01-23 19:49:17.500919 E  Not allowed to upgrade the database.
2013-01-23 19:49:17.502557 E  Incorrect database schema
2013-01-23 19:49:17.503042 E  Error preparing query: INSERT INTO  
logging     (host, application, pid, tid, thread, filename,      line,  
function, msgtime, level, message) VALUES (:HOST, :APP, :PID, :TID,  
:THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
mythfilldatabase




Or is this a good time to install Mythbuntu 12.04?



More information about the mythtvnz mailing list