[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