[mythtv-users] Changing hostname instructions

Alan Snyder ax763 at yahoo.com
Wed Jan 7 11:53:37 EST 2004


> 
> On Tuesday 06 January 2004 11:34 pm, J. Donavan
Stanley wrote:
> > Whats wrong with just using a simple SQL update to
change 
> the hostname?
> >   No need to drop - grep - restore if all you want
to do is 
> change all 
> > occurances of hostxxx with hostyyy...
> >
> > UPDATE <tablename> SET hostname='hostyyy' WHERE
hostname='hostxxx';
> >
> > Or am I missing something?
> 
> Any table that uses a timestamp field would get
broken with 
> that approach.
> 

Which was precisely Kirby's warning about editing the
database in-place.


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus


More information about the mythtv-users mailing list