>>> [EMAIL PROTECTED] 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
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
