LinHES Forums
http://forums.linhes.org/

Migrating recordings to a new machine
http://forums.linhes.org/viewtopic.php?f=3&t=19431		 Page 1 of 1
Author:  nmcaullay [ Tue Jan 13, 2009 10:25 pm ]
Post subject:  Migrating recordings to a new machine
Hi all,

Not sure if this will help anyone, but i think i have solved my mythbackend segfault issue after upgrading from my old P4/mobo to a much more grunty AMD64 5200 dual processor and mobo.

The story:
I exported the recorded (and other tables) from the old R5.5 backend, and imported them into the fresh R5.5 backend. I noticed that i was getting frequent mythbacken segfault crashes when deleting recordings (after watching etc). The pattern seemed to form that if i deleted a recording from the old P4 box the segfault would occure, but not on new recordings.

The solution (fingers crossed)
The new machine has a new hostname (different to the old P4 box), so i think a simple msql sql update commend to update the hostname field in the recorded table to the new hostname has stopped the crashing/segfaults.

The future
Hopefully this has resolved the problem, i will post back if not.

Cheers,

Nathan
Author:  novellahub [ Wed Jan 14, 2009 10:25 am ]
Post subject: 
The Mythtv wiki has instructions on changing host names here:

http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.15

Last year when I migrated from R5F27 to R5.5 I used this command below in mysql to update the hostname:

Code:
UPDATE recorded SET hostname='newhost',starttime=starttime,endtime=endtime
WHERE hostname='oldhost';


I had a secondary backend / frontend that could not play recordings from the master because the migrated recordings had the old hostname. The command above fixed the issue.
Author:  tjc [ Thu Jan 15, 2009 9:46 pm ]
Post subject: 
I've also posted a script which makes the substitutions in the DB for things like recordings and such.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/