[mythtv-users] How-to Moving History of Recordings to NewBackend?

PAUL WILLIAMSON pwilliamson at mandtbank.com
Wed Jan 26 16:05:55 EST 2005


>>> t.tait at comcast.net 1/26/2005 3:02:31 PM >>>
>
>I've googled for this but not found an answer. I'm sure 
>it would not be that hard if I understood more about 
>MySQL and the data stored.
>
>How does one move the history of what has been 
>recorded to a new backend (not a slave)? I want to avoid 
>re-recording episodes long since viewed 
>and deleted on the old backend.
>
>Thanks-
>
>Tim

I'm not sure if you just want the recorded table or the whole 
mythconverg database.  If you want the whole ball of 
wax for a new install...

Create the mythconverg table on your new backend with 

# mysqladmin create mythconverg 
(I don't think it has an e, does it?)

Then dump out the entire contents of the myth db...

# mysqldump --quick mythconverg | gzip > mythconverg.contents.gz

Then get it over to your new backend...

# scp mythconverg.contents.gz newhost:/
(enter password when propmted)

get over to your other host...

# gunzip < mythconverg.contents.gz | mysql mythconverg

and voila!  Your old database is on your new backend.
I'm not sure if there are entries in any of the tables that 
need to be changed.  You may want to hunt around in your 
old database for any references to your old backend name 
or your old backend ip address.

I do this so often at work it's in a bash script, so I just 
cut and pasted from there to here and changed the 
database name.

Good luck!

Paul



More information about the mythtv-users mailing list