[mythtv-users] Corrupt/missing weather DB tables

Michael Jones michael at michaelandholly.com
Thu May 22 06:07:17 UTC 2008


On May 21, 2008, at 9: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.
>
> Chuck

For some reason mine did the same thing at one time.. I found the  
database definitions either on the list archive or just through a  
google search on the name of the table.. (can't remember)..

Sorry... I didn't keep the file..


- Michael


> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



More information about the mythtv-users mailing list