Page 1 of 1

Catchup Custom MySQL

Posted: Tue 21 Jan 2025 12:06 am
by BrunswickWeather
This may not be possible!
I have a custom MySQL uploading every 10mins which includes extra sensors but also normal data like outside temp.

"INSERT IGNORE INTO extralogssensors (Dateold, Time, date, Month ,FourthTemp , FourthHumidty , Temp , Humidty , Extraintemp , Extrainhum , InTemp , InHum , SoilMoisture1 , SoilMoisture2 , SoilMoisture3) VALUES ('<#date > <#timehhmmss >','<#timehhmmss >','<#metdate >','<#year>-<#month>',<#ExtraTemp1>,<#ExtraHum1>,<#temp>,<#hum>,<#ExtraTemp2>,<#ExtraHum2>,<#intemp>,<#inhum>,<#SoilMoisture1>,<#SoilMoisture2> ,<#SoilMoisture3>);"

The PC is often shutdown overnight so all the data for this time is not uploaded into the MySQL at startup.
The Extralog txt files are updated with data from overnight. e.g. ExtraLog202501.txt
Within the MySQL settings page I have set the custom upload at startup, this would only load one entry?
Is there a solution or am I missing a setting I should set?

Re: Catchup Custom MySQL

Posted: Tue 21 Jan 2025 12:37 am
by BrunswickWeather
Attached Diags file from this morning. The custom startup wasn't set then

After setting the startup it causes an error. Also attached a later diag file show the startup error

Re: Catchup Custom MySQL

Posted: Tue 21 Jan 2025 11:16 am
by mcrossley
It's not possible at present, the main station is "caught up" but extra sensors are not.

Re: Catchup Custom MySQL

Posted: Sat 25 Jan 2025 7:06 am
by BrunswickWeather
Thanks Mark

Decided to leave my Mini pc on 24/7. (NucBox_M2Pro)

Checking power usage it appears to use only 0.03kw per hour at 22c per kw/hr. So for about 10hrs extra per day its not expensive.

Re: Catchup Custom MySQL

Posted: Sun 26 Jan 2025 11:31 am
by mcrossley
I figured the same, I run "lots" of Raspberry Pis, and few other IoT devices. In total they cost less the price of half a cup coffee per year, a small price to pay to support the hobbies!