I have MythTV 0.20 running on a PC which has an ASROCK K7S11 motherboard. After some googling and testing I was able to get the automatic wakeup for recording working. Included below is the script which is now working with this motherboard. If you have a different motherboard, be careful and don't use this script without understanding what you are doing. Got most of this online from other folks (sorry, can't remember who) and just needed to adapt the processing of the timestamp.
setwakeuptime.sh
#!/bin/bash
# set ACPI Wakup time in UTC format
stamp_file=/home/mythtv/timestamp
#echo $1\ $2 > $stamp_file
#echo $1\ $2 > /home/mythtv/setwakeuptime.inputs.log
# If using mythwelcome you can try the next line instead on the one above.
# echo >$stamp_file
# Read the date in the locale time format and add the time-zone info to the stamp_file
# datum=$(/bin/date -f $stamp_file +%F\ %T\ %z)
datum=$(/bin/date -u -d@$2 +%F\ %T)
echo $datum > $stamp_file
# reinterpret this in utc and write to alarm
# utcdatum=$(/bin/date -u -f $stamp_file +%F\ %T)
# echo $utcdatum > $stamp_file
#rm -f $stamp_file
echo $datum >/proc/acpi/alarm
exit 0
