Excellent postings: The two latest snippets were effective at demonstrating mySQL queries. I captured the output below.
I also tried elgordo123's suggestion and it returned an empty set. That being said, I have come to the conclusion that I can not see the guide data because it was downloaded, but did not make it into the database.
I ran mythfilldatabase again and it seemed to download the guide data: 16:36:45 (76.25 KB/s).... saved [1692181]
Given that information, is there anything else that can be done (from a diagnostic standpoint) to identify the root cause of the problem?
MySQL Data from table = program
========================
value data hostname
mythfilldatabaseLastRunStart 2007-05-18 13:56 NULL
mythfilldatabaseLastRunEnd 2007-05-18 13:56 NULL
mythfilldatabaseLastRunStatus NULL NULL
DataDirectMessage Your subscription expires on 07/27/07 00:21:23 NULL
HaveRepeats 0 NULL
DBSchemaVer 1123 NULL
DefaultTranscoder 0 NULL
MythFillSuggestedRunTime 2007-05-19T09:01:04 NULL
MythFillGrabberSuggestsTime 1 NULL
BackendServerIP 127.0.0.1 mythtvhost40
BackendServerPort 6543 mythtvhost40
BackendStatusPort 6544 mythtvhost40
MasterServerIP 127.0.0.1 NULL
MasterServerPort 6543 NULL
RecordFilePrefix /myth/tv mythtvhost40
SaveTranscoding 0 NULL
TVFormat NTSC NULL
VbiFormat NTSC Closed Caption mythtvhost40
FreqTable us-cable NULL
TimeOffset None NULL
EITTransportTimeout 5 NULL
MasterBackendOverride 1 NULL
DeletesFollowLinks 1 NULL
startupCommand NULL
blockSDWUwithoutClient 1 NULL
idleTimeoutSecs 0 NULL
idleWaitForRecordingTime 15 NULL
StartupSecsBeforeRecording 120 NULL
WakeupTimeFormat hh:mm yyyy-MM-dd NULL
SetWakeuptimeCommand NULL
ServerHaltCommand sudo /sbin/halt -p NULL
preSDWUCheckCommand NULL
WOLbackendReconnectWaitTime 0 NULL
WOLbackendConnectRetry 5 NULL
WOLbackendCommand NULL
WOLslaveBackendsCommand NULL
JobQueueMaxSimultaneousJobs 1 mythtvhost40
JobQueueCheckFrequency 60 mythtvhost40
JobQueueWindowStart 00:00 mythtvhost40
JobQueueWindowEnd 23:59 mythtvhost40
JobQueueCPU 0 mythtvhost40
JobAllowCommFlag 1 mythtvhost40
JobAllowTranscode 1 mythtvhost40
JobAllowUserJob1 0 mythtvhost40
JobAllowUserJob2 0 mythtvhost40
JobAllowUserJob3 0 mythtvhost40
JobAllowUserJob4 0 mythtvhost40
JobsRunOnRecordHost 0 NULL
AutoTranscodeBeforeAutoCommflag 0 NULL
AutoCommflagWhileRecording 0 NULL
UserJobDesc1 User Job #1 NULL
UserJob1 NULL
UserJobDesc2 User Job #2 NULL
UserJob2 NULL
UserJobDesc3 User Job #3 NULL
UserJob3 NULL
UserJobDesc4 User Job #4 NULL
UserJob4 NULL
Deinterlace 1 mythtvhost40
DeinterlaceFilter linearblend mythtvhost40
CustomFilters mythtvhost40
PreferredMPEG2Decoder ffmpeg mythtvhost40
UseOpenGLVSync 0 mythtvhost40
RealtimePriority 1 mythtvhost40
UseVideoTimebase 0 mythtvhost40
DecodeExtraAudio 1 mythtvhost40
AspectOverride 0 mythtvhost40
PIPLocation 0 mythtvhost40
PlaybackExitPrompt 2 mythtvhost40
EndOfRecordingExitPrompt 1 mythtvhost40
ClearSavedPosition 1 mythtvhost40
AltClearSavedPosition 1 mythtvhost40
UseOutputPictureControls 0 mythtvhost40
AudioNag 1 mythtvhost40
UDPNotifyPort 6948 mythtvhost40
PlayBoxOrdering 1 mythtvhost40
PlayBoxEpisodeSort Date mythtvhost40
GeneratePreviewPixmaps 0 mythtvhost40
PreviewPixmapOffset 64 NULL
PreviewFromBookmark 1 mythtvhost40
PlaybackPreview 1 mythtvhost40
PlaybackPreviewLowCPU 1 mythtvhost40
PlaybackBoxStartInTitle 1 mythtvhost40
ShowGroupInfo 0 mythtvhost40
AllRecGroupPassword NULL
DisplayRecGroup All Programs mythtvhost40
QueryInitialFilter 0 mythtvhost40
RememberRecGroup 1 mythtvhost40
DispRecGroupAsAllProg 0 mythtvhost40
LiveTVInAllPrograms 1 mythtvhost40
DisplayGroupDefaultView 0 mythtvhost40
PVR350OutputEnable 0 mythtvhost40
PVR350VideoDev /dev/video16 mythtvhost40
PVR350EPGAlphaValue 164 mythtvhost40
PVR350InternalAudioOnly 0 mythtvhost40
SmartForward 0 mythtvhost40
StickyKeys 0 mythtvhost40
FFRewReposTime 100 mythtvhost40
FFRewReverse 1 mythtvhost40
ExactSeeking 0 mythtvhost40
AutoCommercialSkip 0 mythtvhost40
CommRewindAmount 0 mythtvhost40
CommNotifyAmount 0 mythtvhost40
CommSkipAllBlanks 1 NULL
VertScanPercentage 0 mythtvhost40
HorizScanPercentage 0 mythtvhost40
XScanDisplacement 0 mythtvhost40
YScanDisplacement 0 mythtvhost40
OSDTheme Titivillus-OSD mythtvhost40
OSDGeneralTimeout 2 mythtvhost40
OSDProgramInfoTimeout 3 mythtvhost40
OSDNotifyTimeout 5 mythtvhost40
OSDFont FreeMono.ttf mythtvhost40
OSDCCFont FreeMono.ttf mythtvhost40
OSDThemeFontSizeType default mythtvhost40
CCBackground 0 mythtvhost40
DefaultCCMode 0 mythtvhost40
PersistentBrowseMode 1 mythtvhost40
ChannelOrdering channum + 0 mythtvhost40
ChannelFormat <num> <sign> mythtvhost40
LongChannelFormat <num> <name> mythtvhost40
SmartChannelChange 0 mythtvhost40
LastFreeCard 0 NULL
AutoExpireMethod 2 NULL
AutoExpireDefault 1 NULL
AutoExpireLiveTVMaxAge 1 NULL
AutoCommercialFlag 1 NULL
CommercialSkipMethod 1 NULL
AggressiveCommDetect 1 NULL
AutoTranscode 0 NULL
AutoRunUserJob1 0 NULL
AutoRunUserJob2 0 NULL
AutoRunUserJob3 0 NULL
AutoRunUserJob4 0 NULL
AutoExpireExtraSpace 1 NULL
RecordPreRoll 0 NULL
RecordOverTime 0 NULL
OverTimeCategory category name NULL
CategoryOverTime 30 NULL
ATSCCheckSignalThreshold 65 NULL
ATSCCheckSignalWait 5000 NULL
HDRingbufferSize 9400 NULL
EPGFillType 12 mythtvhost40
EPGShowCategoryColors 1 mythtvhost40
EPGShowCategoryText 1 mythtvhost40
EPGScrollType 1 mythtvhost40
EPGShowChannelIcon 1 mythtvhost40
EPGShowFavorites 0 mythtvhost40
WatchTVGuide 0 mythtvhost40
chanPerPage 5 mythtvhost40
timePerPage 4 mythtvhost40
UnknownTitle Unknown mythtvhost40
UnknownCategory Unknown mythtvhost40
DefaultTVChannel 3 mythtvhost40
SelectChangesChannel 0 mythtvhost40
SelChangeRecThreshold 16 mythtvhost40
EPGEnableJumpToChannel 1 NULL
Theme Titivillus mythtvhost40
Style mythtvhost40
ThemeFontSizeType default mythtvhost40
RandomTheme 0 mythtvhost40
MenuTheme Default mythtvhost40
GuiWidth 0 mythtvhost40
GuiHeight 0 mythtvhost40
GuiOffsetX 0 mythtvhost40
GuiOffsetY 0 mythtvhost40
GuiSizeForTV 1 mythtvhost40
HideMouseCursor 1 mythtvhost40
RunFrontendInWindow 0 mythtvhost40
UseVideoModes 0 mythtvhost40
GuiVidModeResolution 640x480 mythtvhost40
TVVidModeResolution 400x300 mythtvhost40
TVVidModeForceAspect 0.0 mythtvhost40
VidModeWidth0 0 mythtvhost40
VidModeHeight0 0 mythtvhost40
TVVidModeResolution0 400x300 mythtvhost40
TVVidModeForceAspect0 0.0 mythtvhost40
VidModeWidth1 0 mythtvhost40
VidModeHeight1 0 mythtvhost40
TVVidModeResolution1 400x300 mythtvhost40
TVVidModeForceAspect1 0.0 mythtvhost40
VidModeWidth2 0 mythtvhost40
VidModeHeight2 0 mythtvhost40
TVVidModeResolution2 400x300 mythtvhost40
TVVidModeForceAspect2 0.0 mythtvhost40
DateFormat ddd MMM d mythtvhost40
ShortDateFormat M/d mythtvhost40
TimeFormat h:mm AP mythtvhost40
QtFontSmall 12 mythtvhost40
QtFontMedium 16 mythtvhost40
QtFontBig 25 mythtvhost40
PlayBoxTransparency 1 mythtvhost40
PlayBoxShading 0 mythtvhost40
UseVirtualKeyboard 1 mythtvhost40
LCDEnable 0 mythtvhost40
LCDShowTime 1 mythtvhost40
LCDShowMenu 1 mythtvhost40
LCDShowMusic 1 mythtvhost40
LCDShowMusicItems ArtistTitle mythtvhost40
LCDShowChannel 1 mythtvhost40
LCDShowRecStatus 0 mythtvhost40
LCDShowVolume 1 mythtvhost40
LCDShowGeneric 1 mythtvhost40
LCDBacklightOn 1 mythtvhost40
LCDHeartBeatOn 0 mythtvhost40
LCDKeyString ABCDEF mythtvhost40
LCDPopupTime 5 mythtvhost40
AudioOutputDevice /dev/dsp mythtvhost40
AC3PassThru 0 mythtvhost40
DTSPassThru 0 mythtvhost40
AggressiveSoundcardBuffer 0 mythtvhost40
MythControlsVolume 1 mythtvhost40
MixerDevice /dev/mixer mythtvhost40
MixerControl PCM mythtvhost40
MasterMixerVolume 70 mythtvhost40
PCMMixerVolume 70 mythtvhost40
IndividualMuteControl 0 mythtvhost40
AllowQuitShutdown 4 mythtvhost40
NoPromptOnExit 1 mythtvhost40
HaltCommand sudo halt mythtvhost40
LircKeyPressedApp mythtvhost40
UseArrowAccels 1 mythtvhost40
NetworkControlEnabled 0 mythtvhost40
NetworkControlPort 6546 mythtvhost40
SetupPinCodeRequired 0 mythtvhost40
MonitorDrives 1 mythtvhost40
EnableXbox 0 mythtvhost40
LogEnabled 0 NULL
LogPrintLevel 8 mythtvhost40
LogCleanEnabled 0 mythtvhost40
LogCleanPeriod 14 mythtvhost40
LogCleanDays 14 mythtvhost40
LogCleanMax 30 mythtvhost40
LogMaxCount 100 mythtvhost40
MythFillEnabled 1 NULL
MythFillDatabasePath /usr/bin/mythfilldatabase NULL
MythFillDatabaseArgs --quiet mythtvhost40
MythFillDatabaseLog NULL
MythFillPeriod 1 NULL
MythFillMinHour 9 NULL
MythFillMaxHour 11 NULL
SchedMoveHigher 0 NULL
SingleRecordRecPriority 1 NULL
OverrideRecordRecPriority 0 NULL
FindOneRecordRecPriority -1 NULL
WeekslotRecordRecPriority 0 NULL
TimeslotRecordRecPriority 0 NULL
ChannelRecordRecPriority 0 NULL
AllRecordRecPriority 0 NULL
BurnScriptPath /myth/mythburn mythtvhost40
BurnVideoFormat NTSC mythtvhost40
DVDDBSchemaVer 1001 NULL
DVDDeviceLocation /mnt/cdrom mythtvhost40
VCDDeviceLocation /mnt/cdrom mythtvhost40
DVDOnInsertDVD 1 mythtvhost40
DVDPlayerCommand xine -pfhq --no-splash dvd:// mythtvhost40
VCDPlayerCommand xine -pfhq --no-splash vcd:// mythtvhost40
DVDRipLocation /myth/tmp mythtvhost40
TitlePlayCommand mplayer dvd://%t -dvd-device %d -fs -zoom -vo xv -aid %a -channels %c mythtvhost40
SubTitleCommand -sid %s mythtvhost40
TranscodeCommand transcode mythtvhost40
MTDPort 2442 mythtvhost40
MTDNiceLevel 20 mythtvhost40
MTDConcurrentTranscodes 1 mythtvhost40
MTDRipSize 0 mythtvhost40
MTDLogFlag 0 mythtvhost40
MTDac3Flag 0 mythtvhost40
MTDxvidFlag 1 mythtvhost40
GalleryDBSchemaVer 1000 NULL
GalleryDir /myth/gallery mythtvhost40
GalleryThumbnailLocation 1 mythtvhost40
GalleryImportDirs /mnt/cdrom:/mnt/camera mythtvhost40
GalleryMoviePlayerCmd mplayer -fs %s mythtvhost40
SlideshowOpenGLTransition none mythtvhost40
SlideshowTransition none mythtvhost40
SlideshowBackground mythtvhost40
SlideshowDelay 5 mythtvhost40
GameDBSchemaVer 1012 NULL
MusicDBSchemaVer 1005 NULL
MusicLocation /myth/music/ mythtvhost40
MusicAudioDevice default mythtvhost40
CDDevice /dev/cdrom mythtvhost40
TreeLevels splitartist artist album title mythtvhost40
NonID3FileNameFormat GENRE/ARTIST/ALBUM/TRACK_TITLE mythtvhost40
Ignore_ID3 0 mythtvhost40
AutoLookupCD 1 mythtvhost40
AutoPlayCD 0 mythtvhost40
KeyboardAccelerators 1 mythtvhost40
CDWriterEnabled 1 mythtvhost40
CDWriterDevice ATA:1,0,0 mythtvhost40
CDDiskSize 1 mythtvhost40
CDCreateDir 1 mythtvhost40
CDWriteSpeed 0 mythtvhost40
CDBlankType fast mythtvhost40
PlayMode Normal mythtvhost40
IntelliRatingWeight 35 mythtvhost40
IntelliPlayCountWeight 25 mythtvhost40
IntelliLastPlayWeight 25 mythtvhost40
IntelliRandomWeight 15 mythtvhost40
MusicShowRatings 0 mythtvhost40
ShowWholeTree 0 mythtvhost40
ListAsShuffled 0 mythtvhost40
VisualMode Random mythtvhost40
VisualCycleOnSongChange 0 mythtvhost40
VisualModeDelay 0 mythtvhost40
VisualScaleWidth 1 mythtvhost40
VisualScaleHeight 1 mythtvhost40
ParanoiaLevel Full mythtvhost40
FilenameTemplate ARTIST/ALBUM/TRACK-TITLE mythtvhost40
TagSeparator - mythtvhost40
NoWhitespace 0 mythtvhost40
PostCDRipScript mythtvhost40
EjectCDAfterRipping 1 mythtvhost40
OnlyImportNewMusic 1 mythtvhost40
EncoderType ogg mythtvhost40
DefaultRipQuality 1 mythtvhost40
Mp3UseVBR 0 mythtvhost40
PhoneDBSchemaVer 1001 NULL
SipRegisterWithProxy 1 mythtvhost40
SipProxyName fwd.pulver.com mythtvhost40
SipProxyAuthName mythtvhost40
SipProxyAuthPassword mythtvhost40
MySipName Me mythtvhost40
SipAutoanswer 0 mythtvhost40
SipBindInterface eth0 mythtvhost40
SipLocalPort 5060 mythtvhost40
NatTraversalMethod None mythtvhost40
NatIpAddress
http://checkip.dyndns.org mythtvhost40
AudioLocalPort 21232 mythtvhost40
VideoLocalPort 21234 mythtvhost40
MicrophoneDevice None mythtvhost40
CodecPriorityList GSM;G.711u;G.711a mythtvhost40
PlayoutAudioCall 40 mythtvhost40
PlayoutVideoCall 110 mythtvhost40
WebcamDevice /dev/video mythtvhost40
TxResolution 176x144 mythtvhost40
TransmitFPS 5 mythtvhost40
TransmitBandwidth 256 mythtvhost40
CaptureResolution 352x288 mythtvhost40
TimeToAnswer 10 mythtvhost40
DefaultVxmlUrl
http://127.0.0.1/vxml/index.vxml mythtvhost40
DefaultVoicemailPrompt I am not at home, please leave a message after the tone mythtvhost40
VideoDBSchemaVer 1007 NULL
VideoStartupDir /myth/video mythtvhost40
VideoArtworkDir /myth/video/.covers mythtvhost40
VideoDefaultParentalLevel 4 mythtvhost40
VideoAggressivePC 0 mythtvhost40
VideoListUnknownFiletypes 1 mythtvhost40
VideoBrowserNoDB 0 mythtvhost40
VideoGalleryNoDB 0 mythtvhost40
VideoTreeNoDB 0 mythtvhost40
VideoTreeLoadMetaData 1 mythtvhost40
VideoNewBrowsable 1 mythtvhost40
Default MythVideo View 1 mythtvhost40
MovieListCommandLine /usr/share/mythtv/mythvideo/scripts/imdb.pl -M tv=no;video=no mythtvhost40
MoviePosterCommandLine /usr/share/mythtv/mythvideo/scripts/imdb.pl -P mythtvhost40
MovieDataCommandLine /usr/share/mythtv/mythvideo/scripts/imdb.pl -D mythtvhost40
VideoGalleryColsPerPage 4 mythtvhost40
VideoGalleryRowsPerPage 3 mythtvhost40
VideoGallerySubtitle 1 mythtvhost40
VideoGalleryAspectRatio 1 mythtvhost40
VideoDefaultPlayer mplayer -fs -zoom -quiet -vo xv %s mythtvhost40
TVVidModeRefreshRate 0 mythtvhost40
TVVidModeRefreshRate0 0 mythtvhost40
TVVidModeRefreshRate1 0 mythtvhost40
TVVidModeRefreshRate2 0 mythtvhost40
GalleryRecursiveSlideshow 1 mythtvhost40
GameAllTreeLevels system gamename mythtvhost40
GameFavTreeLevels gamename mythtvhost40
WebBrowserZoomLevel 20 mythtvhost40
WebBrowserCommand /usr/bin/mythbrowser mythtvhost40
WebBrowserScrollMode 1 mythtvhost40
WebBrowserScrollSpeed 4 mythtvhost40
WebBrowserHideScrollbars 0 mythtvhost40
SIUnits NO mythtvhost40
UseXvMcVld 0 mythtvhost40
Language EN mythtvhost40
locale 32080 mythtvhost40
ISO639Language0 eng mythtvhost40
ISO639Language1 eng mythtvhost40
WebDBSchemaVer 1 NULL