[mythtv-users] merge recordings in mythtv

Adam Brown abrown at spsu.edu
Sun Jan 31 04:10:56 UTC 2010


Thanks. Worked great!!!

On Sat, Jan 30, 2010 at 7:47 PM, Daniel Di Giacomo <lists at dadigi.com> wrote:
>
>> Hi,
>>
>> I have both a master and a slave backend. Recently, my master backend
>> went down. During that time I turned the slave into the master, and
>> have recorded shows on it. Now I've got my original master working
>> again. I've copied the recordings (the actual files) from my temporary
>> master back to the original master. Now, how can I merge the recorded
>> database information from my temporary backend to my original master
>> backend?
>>
>> Will a mysqldump on certain tables work?
>>
>> Thanks. Any help appreciated.
>>
>> --
>> Adam
>
> Hi Adam,
>
> I use the following script to move recordings regularly from my
> slave-backend to the master. The sql-statement in it should do the job for
> you.
> Or, to keep it simple: You just have to change the field "hostname" in the
> table "recorded" for the moved files.
>
> move2master.sh:
> #!/bin/bash
> DIR=
> FILE=$1
> FILEPATH="${DIR}/${FILE}"
> /bin/mv ${FILEPATH}*
> /usr/bin/mysql -BNe "UPDATE recorded SET hostname = '' WHERE basename =
> '${FILE}'"
>
> The destination directory is part of the default storage group of my
> master-backend and is nfs-mounted on my slave-backend.
>
> Regards,
> Daniel
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>



-- 
Adam


More information about the mythtv-users mailing list