[mythtv-users] Corrupt/missing weather DB tables - SOLVED

[Dusty Herrman]

This worked!  I deleted the 'WeatherDBSchemaVer' value from the settings 
table, deleted the corrupted .frm files.  I had to run mythtv-setup for 
it to create the needed tables, but now everything is back to normal.

Chuck Filson wrote:
> On May 21, 2008 11:56:59 pm Dusty Herrman wrote:
>   
>> I just had a power surge and it looks like I have some corrupted/missing
>> DB tables.  Can someone please give me the descriptions of the tables
>> (and maybe some of the data in them)?
>>
>> The tables are: weatherdatalayout, weatherscreens, and
>> weathersourcesettings.
>>
>> Thanks in advance
>>     
>
> 	Backup your database first ... then try the following.
>
> 	Delete the value of "WeatherDBSchemaVer" in the database and also delete 
> those three tables, then MythWeather should create and update the tables the 
> next time it runs.
>
> Chuck
>