$ su
# /etc/init.d/mythbackend stop

$ su
# /etc/init.d/mythtv-backend stop

root@black2:~# cat change_hostname.sh
#!/bin/bash

old="$1"
new="$2"

fatal () {
    echo "Error! $*"
    exit 1
}
nl='
'
usage () {
    fatal "$*${nl}Usage: $0 old_hostname new_hostname"
}

[ $(id -u) -ne 0 ] && fatal "You must run this script as root!"
[ $# -ne 2 ] && usage "Bad argument count!"
[ -z "$old" ] && fatal "Old hostname can not be blank!"
[ -z "$new" ] && fatal "New hostname can not be blank!"

echo
echo "=============================== WARNING! =============================="
echo "This only changes the hostnames stored in the database. Also, if mysql"
echo "complains about uniqueness you'll need to resolve the issue manually."
echo "=============================== WARNING! =============================="
echo
read -p "Hit enter to continue, or Ctrl-C to abort."

# Tables which contain hostname
for table in capturecard inuseprograms jobqueue jumppoints keybindings \
             music_playlists musicplaylist profilegroups recorded settings ; do
    mysql mythconverg -u root -e \
        "update $table set hostname = '$new' where hostname = '$old'"
done

# Tables which contain host
for table in mythlog ; do
    mysql mythconverg -u root -e \
        "update $table set host = '$new' where host = '$old'"
done