[mythtv-users] Re: Clean 0.15 install, what should I save from the old DB?

[Bruce Markey]

Aleaxander wrote:
> Bruce Markey wrote:
> 
>>> ----
>>>
>>> Everything looked good until I did the last step, and then received 
>>> the following error:
>>>
>>> ERROR 1054 at line 1: Unknown column 'recorddups' in 'field list'
>>>
>>> Looking at a backup of the 0.15 mythconverg database I made before I 
>>> started trying to restore information from the 0.14 database I see 
>>> that there is no recorddups field present.  Anyone have any idea what 
>>> I am doing wrong or suggestions on how I can proceed?
>>
>>
>>
>> That column was dropped and replaced with two other columns.
>>
>>  ALTER TABLE record ADD COLUMN recorddups INT DEFAULT 0 NOT NULL;
>>
>> Run the restore command again then:
>>
>>  UPDATE record SET dupmethod = 1 WHERE recorddups = 2;
>>  UPDATE record SET dupin = 2 WHERE recorddups = 1;
>>  ALTER TABLE record DROP COLUMN recorddups;
>>
>> --  bjm
> 
> 
> Still running into problems.  I restored mythconverg from a backup made 
> of 0.15, deleted the restore.sql file I had created earlier and started 
> over, just in case I had messed something up in previous attempts, then 
> followed the instructions again, as I understand them, doing:
> 
> $ grep "INSERT INTO record " mythtv_backup.sql > restore.sql
> $ grep "INSERT INTO recorded " mythtv_backup.sql >> restore.sql
> $ grep "INSERT INTO oldrecorded " mythtv_backup.sql >> restore.sql
> $ grep "INSERT INTO recordedmarkup " mythtv_backup.sql >> restore.sql
> $ mysql -u root -p mythconverg
> mysql> ALTER TABLE record ADD COLUMN recorddups INT DEFAULT 0 NOT NULL;
> mysql> exit
> $ mysql -u mythtv -pmythtv mythconverg < restore.sql
> 
> Then got this error:
> ERROR 1054 at line 1: Unknown column 'preroll' in field list'
> 
> Doh!  Okay, so I did the following:
> mysql> ALTER TABLE record ADD COLUMN preroll INT DEFAULT 0 NOT NULL;
> mysql> exit
> $ mysql -u mythtv -pmythtv mythconverg < restore.sql
> 
> Then got this error (at this point I know I'm probably going down the 
> path of messing up the database, but I'm desperate):
> ERROR 1054 at line 1: Unknown column 'postroll' in field list'
> 
> Doh!  Doh!  How many fields am I missing?  This can't be good, but I 
> keep going doing knowing that I'm probably destroying the database:
> mysql> ALTER TABLE record ADD COLUMN postroll INT DEFAULT 0 NOT NULL;
> mysql> exit
> $ mysql -u mythtv -pmythtv mythconverg < restore.sql
> 
> At which point I get this error:
> ERROR 1048 at line 1: Column 'subtitle' cannot be null
> 
> I'm wondering if because I've started with fresh and unused 0.15 
> database, are there fields that have not yet been created by Mythtv? I'm 
> stuck at this point and would really appreciate any help or a push in 
> the right direction.  I'm desperate!

Well, you are certainly making a gallant effort. The "preroll"
and "postroll" fields were renamed "startoffset" and "endoffset".
Several fields no longer allow NULL so the INSERT statements should
now have "''" in place of "NULL". You could try editing your
restore file to search and replace for each of these but then
it would likely reveal the next difference.

Here is what I think is your best bet to get back on track.

1) Temporarily reinstall 0.14, the version you were running when
you made the backup (but don't run it yet).

2) empty your db:

$ mysql -u mythtv -pmythtv mythconverg
mysql> drop database mythconverg;
mysql> create database mythconverg;

3) Run the 0.14 version of ./setup/setup . Let it do the database
updates then you should exit without doing any of the configuration.

4) You should now have a database schema that matches the backup
data. Now do your restore:

$ mysql -u mythtv -pmythtv mythconverg < restore.sql

Hopefully this will run without errors since the tables and columns
match.

5) Install 0.15.1 . Run the 0.15.1 version of ./setup/setup . Let
it do the database updates. If all goes well, do the configuration
for General, Capture cards, Video sources, and Input connections.
Run mythfilldatabase then start mythbackend.

6) Start mythfrontend and go to TV->Watch Recordings to verify that
your recordings are listed.

7) If it's all good, go to Setup->TV Settings and go through each
page to complete your configuration.

--  bjm