Catchup Custom MySQL
Posted: Tue 21 Jan 2025 12:06 am
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?
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?