<div dir="ltr"><div>I tried starting with empty db, then running mythtv-setup and sitll got the weather error. Not sure what was going wrong, but after some reading, I used the restore script<br><br>/usr/share/mythtv/<a href="http://mythconverg_restore.pl">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg.sql --directory /root<br><br></div>and everything seems much better.<br><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Oct 26, 2014 at 5:05 PM, Scott Bickford <span dir="ltr"><<a href="mailto:bic1ster@gmail.com" target="_blank">bic1ster@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>I'm on .27-fixes. This was a .25-fixes db:<br><br>2014-10-26 15:54:36.670293 I Current MythTV Schema Version (DBSchemaVer): 1317<br><br>...<br>2014-10-26 15:54:36.894371 I Current MythMusic Schema Version (MusicDBSchemaVer): 1019<br>2014-10-26 15:54:36.901664 E Backing up database with script: '/usr/share/mythtv/<a href="http://mythconverg_backup.pl" target="_blank">mythconverg_backup.pl</a>'<br>2014-10-26 15:54:37.069205 E DBUtil: Error backing up database: /usr/share/mythtv/<a href="http://mythconverg_backup.pl" target="_blank">mythconverg_backup.pl</a> /tmp/mythtv_db_backup_conf_rOWVav (2)<br>2014-10-26 15:54:37.069218 C Script-based database backup failed. Retrying with internal backup.<br>2014-10-26 15:54:37.070650 C Backing up database to file: '/mnt/storage1/recordings/mythconverg-1317-20141026195437.sql'<br>2014-10-26 15:54:37.169586 E DBUtil: Error backing up database: 'mysqldump --defaults-extra-file='/tmp/mythtv_db_backup_conf_eXOc1O' --host='localhost' --port='3306' --user='mythtv' --add-drop-table --add-locks --allow-keywords --complete-insert --extended-insert --lock-tables --no-create-db --quick 'mythconverg' > '/mnt/storage1/recordings/mythconverg-1317-20141026195437.sql' 2>/dev/null' (2)<br>2014-10-26 15:54:37.240926 I Bonjour: Service registration complete: name 'Mythfrontend on localhost.localdomain' type '_mythfrontend._tcp.' domain: 'local.'<br>2014-10-26 15:54:37.589517 I Bonjour: Service registration complete: name 'MythTV on localhost.localdomain' type '_airplay._tcp.' domain: 'local.'<br>2014-10-26 15:55:06.306648 N Event socket closed. No connection to the backend.<br>2014-10-26 15:55:12.777763 N Upgrading to MythMusic schema version 1020<br>2014-10-26 15:55:12.809399 E DB Error (Performing database upgrade):<br>Query was: CREATE TABLE music_radios ( intid INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, station VARCHAR(128) NOT NULL, channel VARCHAR(128) NOT NULL, url VARCHAR(128) NOT NULL, logourl VARCHAR(128) NOT NULL, genre VARCHAR(128) NOT NULL, metaformat VARCHAR(128) NOT NULL, format VARCHAR(10) NOT NULL, INDEX (station), INDEX (channel));<br>Error was: Driver error was [2/1050]:<br>QMYSQL: Unable to execute query<br>Database error was:<br>Table '`mythconverg`.`music_radios`' already exists<br><br>new version: 1020<br>2014-10-26 15:55:12.809415 E Database schema upgrade failed.<br>2014-10-26 15:55:12.809834 E Couldn't upgrade music database schema, exiting.<br>2014-10-26 15:55:12.809854 E Unable to initialize plugin 'mythmusic'.<br><br></div><div>Looking at phpmyadmin, I don't see music_radios. I also ran a mysql in case phpmyadmin was caching somehow. I can do a select * From music_genres ok.<br><br><br></div>I tried running this both as root and mythtv and it seems to give the same with the backup portion.<br><br><br></div>
</blockquote></div><br></div>