Database issues

[MrData]

Alright -- I have an issue. A database issue.
My meteotemplate had been running nicely for quite a while until one day my SS Guages stopped working.
I also noticed my 'Rain' block, 'interactivGraph' block and notifications weren't functioning either.
These all get data from the database.
Went to my cPanel and checked the database section. It told me I had.....
[humdru6_wx.alldata] Incorrect file format 'alldata'
[humdru6_wx.alldata] Corrupt
Dont really know any of the internal working of the database.
Deleted the old one with the problem and created a new one.
(created a database with a new name in the cPanel,
added the parameters in the MT Main Setup and had it
create the table in the database)
Worked fine for about 6 months then failed the same way again.
Created another database and it failed in a couple of weeks.
Anybody have any ideas why, all of a sudden, this Alldata should be suffering from an
Incorrect File Format after cruising along nicely for a while?

[dmgould]

That just happened to me a couple of weeks ago on one of my sites. I have two of them running MT. My host admitted they had upgraded phpMyAdmin, and that's when the corruption occurred. To complicate things, I had setup weekly backups of my database, and those were all gone too. I discovered I can download my database information from pwsweather.com. When I try to import it back into MT it has problems with the date/time and calculates pressure incorrectly even though it works fine when you click Jachym's button to help get the database conversion setup. I got so frustrated I gave up on the import attempts. Date/time and pressure just don't work going from the csv files into MT.