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

exec >/var/log/mythtv/update_database.log 2>&1

copy_channel () {
  from_chanid=$1
  to_chanid=$2

mysql -u root mythconverg <<EOF
delete from program
where chanid = '$to_chanid';

insert into program
(select '$to_chanid', starttime, endtime, title, subtitle, description,
        category, category_type, airdate, stars, previouslyshown,
        title_pronounce, stereo, subtitled, hdtv, closecaptioned,
        partnumber, parttotal, seriesid, originalairdate, showtype,
        colorcode, syndicatedepisodenumber, programid, manualid,
        generic
        from program
        where chanid = '$from_chanid');

delete from credits
where chanid = '$to_chanid';

insert into credits
(select person, '$to_chanid', starttime, role
        from credits
        where chanid = '$from_chanid');

delete from programgenres
where chanid = '$to_chanid';

insert into programgenres
(select '$to_chanid', starttime, relevance, genre
        from programgenres
        where chanid = '$from_chanid');

delete from programrating
where chanid = '$to_chanid';

insert into programrating
(select '$to_chanid', starttime, system, rating
        from programrating
        where chanid = '$from_chanid');

commit;
EOF
}

fill_options="$*"
if [ -z "$fill_options" -o "$fill_options" = "--quiet" ] ; then
    # fill_options="--refresh-second"
    fill_options=""
fi

/usr/bin/mythfilldatabase $fill_options
sleep 5

echo ;  echo "Fixing AZNTV" ; echo
copy_channel 2251 1098

/usr/bin/mythbackend --resched

echo
echo "Database update completed"