Corrupt database

Post Reply
User avatar
WessexWeather
Forecaster
Forecaster
Posts: 130
Joined: Mon Aug 21, 2017 6:26 pm
Location: Wimborne, East Dorset, UK
Station model: Davis Vantage Vue
Software: Meteobridge
Contact:

Corrupt database

Post by WessexWeather » Sun Sep 17, 2023 11:51 am

I have been running MT flawlessly since 2017 (still on Papaya and PHP 7.4 until all the problems have been ironed out).

Twice in the past 3 weeks my database has become corrupted. Fortunately I pay my host for backups so have been able to roll back to the previous day or two, but this results in gaps in my data, which until recently has been continuous since July 2009.

Has anyone else had this database corruption? Do you think its MT or a problem with my host, or something else?
Regards,

Simon (WessexWeather)

Image

davidefa
Expert
Expert
Posts: 888
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: Corrupt database

Post by davidefa » Mon Oct 09, 2023 7:35 pm

I think it should not be a meteotemplate problem ( not sure about this, but it should not be able to mess with the database itself ).
I took a glimpse to yor july-september data but did not notice any hole ( which I'm currently experiencing due to an unstable internet connection ).
Now I'm testing a gateway with onboard sd to have a backup copy in csv format ( so that I can reimport back to meteotemplate if necessary )
Image

User avatar
WessexWeather
Forecaster
Forecaster
Posts: 130
Joined: Mon Aug 21, 2017 6:26 pm
Location: Wimborne, East Dorset, UK
Station model: Davis Vantage Vue
Software: Meteobridge
Contact:

Re: Corrupt database

Post by WessexWeather » Mon Oct 09, 2023 9:42 pm

I filled the holes with data uploaded to Weather Underground.
Regards,

Simon (WessexWeather)

Image

Post Reply