[mythtv-users] How to add a recording in to the database manually?

[R. G. Newbury]

On 04/22/2011 02:27 PM, Michael T. Dean wrote:
> On 04/22/2011 01:42 PM, malcolm.torrent wrote:
>> so the thermal alarm on my removable HDD enclosure goes off, the server
>> has crashed and the OS HDD is dead. Worse still its 3am.
>>
>> I've been here before, all my recordings are on a separate disks, I'll
>> just rebuild and recover the database.... so whats the problem?
>>
>> You guessed it, the database backups were all stored on the main OS HDD.
>> Ouch what a Muppet....
>>
>> I've rebuilt the system to the latest Mythbuntu (with a raid 1 for the
>> OS and the DB backup on to an NAS NFS share) and now I'm left with ~40
>> orphaned recordings in my newly recovered storage groups.
>>
>> Fortunately, my poor recycling means I still have the last months worth
>> of listing magazines, so I have a potential mechanism of looking up what
>> each recording should be (rather 19th century I know).
>>
>> Assuming I know the real name of the recording (or make it up) and can
>> extract the channel and times from the file-name, what is the
>> recommended 'sql' magic to put a manual entry into the new database so
>> the recording can be seen by the new system.?
>> any advice gratefully received.
>
> The supported solution is to put the recording(s) into your MythVideo
> directories, and then watch it from MythVideo and/or allow re-record so
> that you can get it back into the MythTV recordings area.
>
> Mike

And the unsupported solution used to be to use a perl script called 
myth.rebuilddatabase.pl which asked you for information about files 
found in the video store which were not listed in the db, and added 
them. The script did not enter a filesize into the db. I wrote a script 
to do that.

Together, these scripts bring the db up to date. The programs will show 
up in the recordings list under the name you use and play perfectly.

Unfortunately, the myth.rebuilddatabase.pl script is no longer part of 
the myth tarball package (used to be in mythtv/contrib.

I can send them to you if you would like. Parse my email from the header.

Geoff