[mythtv-users] Unable to upgrade DB

Michael T. Dean mtdean at thirdcontact.com
Sat Mar 27 22:43:56 UTC 2010


On 03/27/2010 02:33 PM, Raymond Wagner wrote:
> On 3/27/2010 13:25, Oz Dror wrote:
>> I fixed the problem by editing  the data base using mysql-query-browser
>>
>> I removed old system in the setting record.
>
> Explain EXACTLY what you did.  Manual editing of the database is ill 
> advised, because as so clearly demonstrated, you have NO idea what 
> you're doing.
>
> As I explained, the error you pasted said that your 0.23 frontend was 
> trying to connect to your 0.22 backend.  The fact that after whatever 
> you did, it is now working means that at some point, you restarted the 
> backend process, allowing the new 0.23 executable to start up.  
> Remember, this isn't Windows, you can delete and edit files right out 
> from under a running program.  When the 0.23 backend started for the 
> first time, it would have automatically upgraded your database to 0.23 
> standards.
>
> Hopefully whatever you did was something innocuous, that won't harm 
> anything.  If you changed the 'DBSchemaVer' to what 0.23 expects, you 
> have now broken your database.  You must close all MythTV processes, 
> and edit that setting back to 1244, before starting the backend up to 
> allow it to properly upgrade things to the structure it will be trying 
> to use.

Or better, drop your database and restore the backup you made before you 
attempted to upgrade (and definitely before you edited anything).

http://www.mythtv.org/wiki/Database_Backup_and_Restore

Mike


More information about the mythtv-users mailing list