Can you give the output of mysql -u mythtv -p mythconverg -e 'SHOW
TABLES;' to see if the tables are created or that there is another
problem?<br><div class="gmail_quote"><div bgcolor="#ffffff" text="#000000">
<br>
Or you can try do to this (I quote Mike for his solution to me on
another matter :)) that should give you a db with all the tables. <br><div class="im">
<br>
Could you try doing a full SQL-based backup ( <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore" target="_blank">http://www.mythtv.org/wiki/Database_Backup_and_Restore</a>
), then dropping your database and creating a new database ( <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore" target="_blank">http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore</a>
), then doing a full restore of the backup ( <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Full_restore_of_a_specific_backup_file" target="_blank">http://www.mythtv.org/wiki/Database_Backup_and_Restore#Full_restore_of_a_specific_backup_file</a>
)?
<br>
<br>
</div></div><br></div>Here is the SHOW TABLES output:<br>Tables_in_mythconverg<br>archiveitems<br>callsignnetworkmap<br>capturecard<br>cardinput<br>channel<br>channelgroup<br>channelgroupnames<br>channelscan<br>channelscan_channel<br>
channelscan_dtv_multiplex<br>codecparams<br>credits<br>customexample<br>diseqc_config<br>diseqc_tree<br>displayprofilegroups<br>displayprofiles<br>dtv_multiplex<br>dtv_privatetypes<br>dvdbookmark<br>dvdinput<br>dvdtranscode<br>
eit_cache<br>filemarkup<br>gallerymetadata<br>housekeeping<br>inputgroup<br>inuseprograms<br>jobqueue<br>jumppoints<br>keybindings<br>keyword<br>music_albumart<br>music_albums<br>music_artists<br>music_directories<br>music_genres<br>
music_playlists<br>music_smartplaylist_categories<br>music_smartplaylist_items<br>music_smartplaylists<br>music_songs<br>music_stats<br>mythconverg.weatherscreens<br>mythlog<br>mythnettv_archive<br>mythnettv_category<br>mythnettv_group<br>
mythnettv_log<br>mythnettv_programs<br>mythnettv_proxies<br>mythnettv_proxy_usage<br>mythnettv_settings<br>mythnettv_subscriptions<br>mythweb_sessions<br>netflix<br>networkiconmap<br>oldfind<br>oldflix<br>oldprogram<br>oldrecorded<br>
people<br>pidcache<br>playgroup<br>powerpriority<br>profilegroups<br>program<br>programgenres<br>programrating<br>recgrouppassword<br>record<br>record_tmp<br>recorded<br>recordedcredits<br>recordedfile<br>recordedmarkup<br>
recordedprogram<br>recordedrating<br>recordedseek<br>recordingprofiles<br>recordmatch<br>schemalock<br>settings<br>storagegroup<br>tvchain<br>tvosdmenu<br>upnpmedia<br>videocast<br>videocategory<br>videocountry<br>videogenre<br>
videometadata<br>videometadatacast<br>videometadatacountry<br>videometadatagenre<br>videosource<br>videotypes<br>weatherdatalayout<br>weatherscreens<br>weathersourcesettings<br><br><br>Oddly enough when I run mysql -u root -p -e 'SELECT COUNT(screen_id) FROM mythconverg.weatherscreens;' I get:<br>
ERROR 1146 (42S02) at line 1: Table 'mythconverg.weatherscreens' doesn't exist<br><br>Also, when I look at the db in phpmyadmin it doesn't show the weather tables.<br><br>Michael Dean suggested that perhaps InnoDB is disabled on my installation. How would I go about verifying that and correcting it if it needs to be active?<br>
<br>I will try the backup / create / restore route if I can't get it resolved by the next time I'm home and the system isn't recording for a day. Which is usually only Saturday.<br>