I had a major commercial power failure about 10 days ago. In the process
it ran the UPS down almost completely such that when the last few power
surge/bumps/fails occured something in the date time pointer system , I
believe in the SQL databse became disconnected and immediate restart of
the program on power restoral Had the local /var/www/html page was a
wrong date and the FTP'd page sent to my web site also had a corrupt
date/Time string and neither agreed nor were either at all real cuurent
time accurate.
I shut down the PC with the intent of looking for a mySQL dB
troubleshooting/repair software application and attempting to correct
the corrupted data when I had time. About a week later I found time to
take a look at the problem and when I restated the PC , with the intent
of halting weewx to troubleshooting the dB. It all came back working
normally but with no back archived data available but it appears the
delay from it being down so long allowed it to restart and regenerate
the consistent web pages and messages.
So although it is back working now, I would like to know if their is a
recommended dB software /data repair/maintenance package available that
is open source freeware either standalone program or possibly something
like a plug option/package to use with a browser similar to phpmyadmin.
My 2nd takeaway is when urgent commercial power fails get to the weewx
PC and shut it down immediately in an orderly fashion before the 8-10
min UPS backup support runs out.
Any pointers are welcome, considering so many outside agancies use the
data (eg AWEKAS, CWOP/NOAA/aprs/ WeatherUnderground in addition to my on
local and www page.
Thanks 73
Andy
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/31c1e793-4db7-672c-ffc0-01361e7aec82%40gmail.com.
