[mythtv-users] merge recordings in mythtv

[Daniel Di Giacomo]

> 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