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

[Bruce Markey]

Kirby Vandivort wrote:
> to do it manually...
> 
> without testing it, why not just do something like:
  ^^^^^^^^^^^^^^^^^^
You're lucky that you didn't try this on your own database.

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

Um, because this will completely mung the timestamp fields
in all the tables that have them. Most notably, the 'recorded'
table making all of your recordings unwatchable until going
through a painstaking recovery process.

OP: DO NOT DO THIS!

> 
> 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.

Now there's a good, solid piece of advice! ;-) One ammendment.
Even if you are a master of mysql and sql you should still
make a backup before trying something like this.

http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5

Once you have a backup you could make a copy and edit the
hostname in the copy then drop mythconverg and restore from
the copy.

--  bjm