[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