5,838
edits
Category:Cumulus MX: Difference between revisions
m
→MySQL settings
m (→FTP Now) |
m (→MySQL settings) |
||
| Line 305: | Line 305: | ||
*# A tick box to enable or disable this upload (so you can leave the SQL recorded, but stop running it when you like. | *# A tick box to enable or disable this upload (so you can leave the SQL recorded, but stop running it when you like. | ||
*# The SQL you want to run, it should include INSERT IGNORE (or REPLACE or UPDATE) to insert a row, the name of the table, the columns to be updated and the values you include in your SQL are expressed as web tags. | *# The SQL you want to run, it should include INSERT IGNORE (or REPLACE or UPDATE) to insert a row, the name of the table, the columns to be updated and the values you include in your SQL are expressed as web tags. | ||
*# | *# A drop down for the number of minutes between runs, the default is 10, but if your weather station updates less frequently, maybe you will choose 15, 20, 30, or 60 as the interval out of the 11 available in drop down. | ||
** One way you could use this option, is to replace the monthly log file upload if you wanted to change the schema, by leaving out some columns if your weather station is not able to measure all the derivatives included in the standard schema. | ** One way you could use this option, is to replace the monthly log file upload if you wanted to change the schema, by leaving out some columns if your weather station is not able to measure all the derivatives included in the standard schema. | ||