hostname originalname

change_hostname.sh old_hostname new_hostname

find /etc /home /root -type f -print0 | xargs -0 grep -li BADHOSTNAME

#!/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 displayprofilegroups inuseprograms jobqueue \
             jumppoints keybindings music_playlists musicplaylist \
             profilegroups recorded settings storagegroup \
             weatherscreens weathersourcesettings ; 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

for table in inuseprograms ; do
    mysql mythconverg -u root -e \
        "update $table set rechost = '$new' where rechost = '$old'"
done

# No idea whether these need attention too...
# dbox2_host capturecard
# hostprefix tvchain