[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