[mythtv-users] Corrupt/missing weather DB tables
Dusty Herrman
djh5983 at ksu.edu
Thu May 22 13:49:51 UTC 2008
On May 21, 2008, at 11:54 PM, 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.
I was wondering if there was something like this :-)
I'll try it and if not, just re-create them by hand.
Thanks everyone who posted!
--
Dusty
More information about the mythtv-users
mailing list