[mythtv-users] Recovering recording meta data from 0.18 DB dump?

[R. G. Newbury]

the following is the output from a 'describe recorded;' from an SVN 
10447 build (schema 1153 I think). Your schema prbably does not have 35 
fields, so you will have to figure out what columns you have and set up 
a new table accordingly.

You say you have the 'meta-data'... surely this was some form of mysql 
backup. mysqldump creates a backup file which is intended to: 1) drop 
the old table; 2) create a new (replacement) table; and 3) insert the 
data into the table.
I don't see how you could end up with only the data portion...


mysql> describe recorded;
+-----------------+------------------+------+-----+---------------------+-------+
| Field           | Type             | Null | Key | Default 
| Extra |
+-----------------+------------------+------+-----+---------------------+-------+
| chanid          | int(10) unsigned | NO   | PRI | 0 
|       |
| starttime       | datetime         | NO   | PRI | 0000-00-00 00:00:00 
|       |
| endtime         | datetime         | NO   | MUL | 0000-00-00 00:00:00 
|       |
| title           | varchar(128)     | NO   | MUL | NULL 
|       |
| subtitle        | varchar(128)     | NO   |     | NULL 
|       |
| description     | text             | NO   |     | NULL 
|       |
| category        | varchar(64)      | NO   |     | NULL 
|       |
| hostname        | varchar(255)     | NO   |     | NULL 
|       |
| bookmark        | tinyint(1)       | NO   |     | 0 
|       |
| editing         | int(10) unsigned | NO   |     | 0 
|       |
| cutlist         | tinyint(1)       | NO   |     | 0 
|       |
| autoexpire      | int(11)          | NO   |     | 0 
|       |
| commflagged     | int(10) unsigned | NO   |     | 0 
|       |
| recgroup        | varchar(32)      | NO   |     | Default 
|       |
| recordid        | int(11)          | YES  | MUL | NULL 
|       |
| seriesid        | varchar(12)      | NO   | MUL | NULL 
|       |
| programid       | varchar(20)      | NO   | MUL | NULL 
|       |
| lastmodified    | timestamp        | YES  |     | CURRENT_TIMESTAMP 
|       |
| filesize        | bigint(20)       | NO   |     | 0 
|       |
| stars           | float            | NO   |     | 0 
|       |
| previouslyshown | tinyint(1)       | YES  |     | 0 
|       |
| originalairdate | date             | YES  |     | NULL 
|       |
| preserve        | tinyint(1)       | NO   |     | 0 
|       |
| findid          | int(11)          | NO   |     | 0 
|       |
| deletepending   | tinyint(1)       | NO   |     | 0 
|       |
| transcoder      | int(11)          | NO   |     | 0 
|       |
| timestretch     | float            | NO   |     | 1 
|       |
| recpriority     | int(11)          | NO   |     | 0 
|       |
| basename        | varchar(128)     | NO   |     | NULL 
|       |
| progstart       | datetime         | NO   |     | 0000-00-00 00:00:00 
|       |
| progend         | datetime         | NO   |     | 0000-00-00 00:00:00 
|       |
| playgroup       | varchar(32)      | NO   |     | Default 
|       |
| profile         | varchar(32)      | NO   |     | NULL 
|       |
| duplicate       | tinyint(1)       | NO   |     | 0 
|       |
| transcoded      | tinyint(1)       | NO   |     | 0 
|       |
+-----------------+------------------+------+-----+---------------------+-------+
35 rows in set (0.01 sec)




Fredrik Karlsson wrote:
> Does nooe know about this?
> 
> Please, I really need help.
> 
> /Fredrik
> 
> On 7/19/06, Fredrik Karlsson <dargosch at gmail.com> wrote:
>> Hi,
>>
>> I have found myself in the not so happy situation that my system disk
>> died and i cannot find the backup disk I made after my upgrade to
>> MythTV 0.19. So, all I have is meta data from the 0.18.1 release,
>> which is different in data base structure compared to 0.19 ( or so
>> MySQL tells me).
>>
>> Does anyone know
>>
>> a) which columns I should fill the data I have into. Specifically, I need a
>> "INSERT INTO recorded (this, part, is, what , I , need) VALUES (these,
>> are, the, ones, I , have, already);" line ;-)
>>
>> b) What do I do with the empty columns? Do I have to fill it with anything?
>>
>> Hope someone is able to help me. I miss my MythTV box! :-)
>>
>> /Fredrik
>>
>> --
>> My Gentoo + PVR-350 + IVTV + MythTV blog is on http://gentoomythtv.blogspot.com/
>>
> 
>