[mythtv-users] Changing hostname (can't find it in the archives)

[Kirby Vandivort]

to do it manually...

without testing it, why not just do something like:

mysql>  update <tablename> set host='newvalue' where host='oldvalue';


before doing this (or any) change to the database directly, i'd suggest
doing a mysqldump if you aren't familiar with mysql and sql.

On Wed, Oct 15, 2003 at 03:14:27PM -0600, Lonny Selinger wrote:
> > Is there a script somewhere to fix the database after
> > a change in hostname, or do I need to manually change
> > every occurrence?
> 
> I had written a script to automate this but I believe there was a fix
> implemented in the source. I'm not sure exactly f it was included in .11 or if
> it was just in CVS and I could be sompletely wrong but I think it allowed you
> to have a null hostname or something similar.
> 
> If you would like I could send you the script I have anyway.
> 
> --
> Lonny
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

-- 

Kirby Vandivort                      Theoretical and 
Senior Research Programmer            Computational Biophysics 
Email: kvandivo at ks.uiuc.edu          3051 Beckman Institute
http://www.ks.uiuc.edu/~kvandivo/    University of Illinois
Phone: (217) 244-5711                405 N. Mathews Ave
Fax  : (217) 244-6078                Urbana, IL  61801, USA