Messmate Farm, Broomfield, Victoria

24-Feb-2018 07:00

❰ Current Conditions       SqlBackup README❯

This page shows a summary of the output from the sqlbackup that last ran on Saturday February 24, 2018 at 07:01
It started the capture from 2018-02-23 06:46:14

Databases :: mysql.weatherpi  mysql.mesoraw  
System ::    disks - memory - mounts  DEBUG output :: logs - mysql - sql  


    Back to top

Extract from the weatherpi Database dump file:

mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1519328774"  --single-transaction --skip-opt


-- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for debian-linux-gnu (i686)
--
-- Host: localhost    Database: weatherpi
-- ------------------------------------------------------
-- Server version	10.1.26-MariaDB-0+deb9u1
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `archive`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `archive` (
  `dateTime` int(11) NOT NULL,
  `usUnits` int(11) NOT NULL,
  `interval` int(11) NOT NULL,
  `barometer` double DEFAULT NULL,
  `pressure` double DEFAULT NULL,
  `altimeter` double DEFAULT NULL,
  `appTemp` double DEFAULT NULL,
  `inTemp` double DEFAULT NULL,
  `outTemp` double DEFAULT NULL,
  `inHumidity` double DEFAULT NULL,
  `outHumidity` double DEFAULT NULL,
  `windSpeed` double DEFAULT NULL,
  `windDir` double DEFAULT NULL,
  `windGust` double DEFAULT NULL,
  `windGustDir` double DEFAULT NULL,
  `rainRate` double DEFAULT NULL,
  `rain` double DEFAULT NULL,
  `dewpoint` double DEFAULT NULL,
  `windchill` double DEFAULT NULL,
  `heatindex` double DEFAULT NULL,
  `ET` double DEFAULT NULL,
  `radiation` double DEFAULT NULL,
  `UV` double DEFAULT NULL,
  `extraTemp1` double DEFAULT NULL,
  `extraTemp2` double DEFAULT NULL,
  `extraTemp3` double DEFAULT NULL,
  `soilTemp1` double DEFAULT NULL,
  `soilTemp2` double DEFAULT NULL,
  `soilTemp3` double DEFAULT NULL,
  `soilTemp4` double DEFAULT NULL,
  `leafTemp1` double DEFAULT NULL,
  `leafTemp2` double DEFAULT NULL,
  `extraHumid1` double DEFAULT NULL,
  `extraHumid2` double DEFAULT NULL,
  `soilMoist1` double DEFAULT NULL,
  `soilMoist2` double DEFAULT NULL,
  `soilMoist3` double DEFAULT NULL,
  `soilMoist4` double DEFAULT NULL,
  `leafWet1` double DEFAULT NULL,
  `leafWet2` double DEFAULT NULL,
  `rxCheckPercent` double DEFAULT NULL,
  `txBatteryStatus` double DEFAULT NULL,
  `consBatteryVoltage` double DEFAULT NULL,
  `hail` double DEFAULT NULL,
  `hailRate` double DEFAULT NULL,
  `heatingTemp` double DEFAULT NULL,
  `heatingVoltage` double DEFAULT NULL,
  `supplyVoltage` double DEFAULT NULL,
  `referenceVoltage` double DEFAULT NULL,
  `windBatteryStatus` double DEFAULT NULL,
  `rainBatteryStatus` double DEFAULT NULL,
  `outTempBatteryStatus` double DEFAULT NULL,
  `inTempBatteryStatus` double DEFAULT NULL,
  `lightning` double DEFAULT NULL,
  `rainCount1` double DEFAULT NULL,
  `rainCount2` double DEFAULT NULL,
  `rainCount3` double DEFAULT NULL,
  `rainCount4` double DEFAULT NULL,
  PRIMARY KEY (`dateTime`),
  UNIQUE KEY `dateTime` (`dateTime`)
);
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `archive`
--
-- WHERE:  dateTime>1519328774

INSERT INTO `archive` VALUES (1519328820,17,1,1013.2285,962.011293464367,1014.69853177913,21.5056780005726,26.007825,20.125,42.9301,85.20315,1.75401547209306,57.3117207969258,2.12344527948965,58.3838383838384,0,0,17.5577978999592,20.125,20.125,0.000280670148153076,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519328880,17,1,1013.12,961.905976206996,1014.58854008346,21.6393170058334,26.078125,20.125,42.925,84.710525,1.50851866288767,58.3838383838384,1.58327060312825,58.3838383838384,0,0,17.4657954730315,20.125,20.125,0.000281464228736503,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.9575,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519328940,17,1,1013.12,961.906551817543,1014.58914124238,21.4035510478603,26.0416666666667,20.1666666666667,42.9269333333333,84.6162,1.91855143673188,41.2108438597524,2.23520555735753,16.3636363636364,0,0,17.4889318359539,20.1666666666667,20.1666666666667,0.000285692789022744,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95666666666667,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329000,17,1,1013.2285,962.009225952835,1014.69637250339,21.5142104350762,26.03125,20.171875,42.924275,84.51545,1.75973419976174,59.7508025677828,2.1763843584797,60,0,0,17.4751336162072,20.171875,20.171875,0.000293481107384847,17.220975,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.955,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329060,17,1,1013.2285,962.008865851936,1014.6959964198,21.5640714016316,26.02345,20.203125,42.930825,84.2762,1.72464257855086,62.4179130438336,1.78816444588602,63.2323232323232,0,0,17.4607643024324,20.203125,20.203125,0.000298250530488967,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329120,17,1,1013.26466666667,962.041355565157,1014.72992814863,21.4777880784571,26,20.1875,42.9317666666667,83.9631,1.78171205511587,58.9973989588381,1.95580486268784,50.3030303030303,0,0,17.3864578811531,20.1875,20.1875,0.000296806721392873,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95666666666667,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329180,17,1,1013.28275,962.060392673759,1014.7498101913,21.6481773657382,26,20.234375,42.9272,84.11735,1.64952614797536,64.4084442146331,1.82345716521272,64.040404040404,0,0,17.4614270307737,20.234375,20.234375,0.00030105354303185,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329240,17,1,1013.337,962.111375786636,1014.80305609871,21.7087127693526,26.0312,20.25,43.0332333333333,83.9248333333333,1.57292242925159,64.8484848484848,1.67640416801815,64.8484848484848,0,0,17.4403783723333,20.25,20.25,0.000299097210029676,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95666666666667,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329300,17,1,1013.337,962.110961871426,1014.80262381271,21.5918707393797,25.968775,20.25,43.087375,83.83695,1.73002652356081,49.0257546348794,1.92476034105787,47.0707070707071,0,0,17.4237652174508,20.25,20.25,0.000299527261769984,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329360,17,1,1013.337,962.184518692333,1014.87944528131,21.7997316579479,25.968725,20.296875,43.168625,84.33555,1.58298838020434,47.0707070707071,1.78816444588602,47.0707070707071,0,0,17.5637045944807,20.296875,20.296875,0.000300626234315054,17.220975,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.9575,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329420,17,1,1013.337,962.145575457278,1014.83877364774,21.8038646801375,26,20.2708333333333,43.2536666666667,84.4665666666667,1.53937256026202,47.0707070707071,1.78816444588602,47.0707070707071,0,0,17.5628488923099,20.2708333333333,20.2708333333333,0.000303838649393136,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329480,17,1,1013.337,962.183537356251,1014.87842039124,21.7251567442642,25.96875,20.296875,43.172225,84.1272,1.66619215432408,53.97301819966,2.23520555735753,67.2727272727273,0,0,17.5244482678828,20.296875,20.296875,0.000300162801941551,17.220975,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.9575,4.93,NULL,20228785,NULL,1230,1382);
INSERT INTO `archive` VALUES (1519329540,17,1,1013.337,962.111358075819,1014.80303760184,21.4124605851292,25.9583666666667,20.25,43.3619333333333,83.9210666666667,1.99571924764065,62.0346292920641,2.23520555735753,60,0,0,17.4396666475202,20.25,20.25,0.000303230222185395,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95333333333333,4.93,NULL,20228785,NULL,1230,1382);

[...]

INSERT INTO `archive` VALUES (1519415340,17,1,1006.43525,957.086899781514,1009.55546591088,26.3609321430929,29.03125,24.640625,36.94215,63.536175,1.08775227711149,8.12965971305691,1.36595895171849,10.7070707070707,0,0,17.2507714506142,24.640625,24.640625,0.000670672330058835,17.220975,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.9525,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415400,17,1,1006.381,957.03532589901,1009.50160069282,26.0483225746047,29.0416333333333,24.625,36.9482333333333,63.5982333333333,1.51242541274192,11.9541521107432,1.80535833478877,11.5151515151515,0,0,17.2514716275726,24.625,24.625,0.000667944335041988,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415460,17,1,1006.381,957.034947570826,1009.5012055561,26.2375048466011,29.0520666666667,24.625,36.9423333333333,63.5323333333333,1.23256985328644,8.23633651722952,1.38369867836418,354.141414141414,0,0,17.2350570000933,24.625,24.625,0.000662217095604023,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95666666666667,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415520,17,1,1006.43525,957.087989087159,1009.55660361217,25.9495955542687,29.01565,24.59375,37.10455,63.90425,1.63604628989919,9.0939708094723,1.9868493843178,337.979797979798,0,0,17.297965181382,24.59375,24.59375,0.0006596049391798,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415580,17,1,1006.52566666667,957.085695994002,1009.55420864151,25.9952030365674,29.0416333333333,24.6041666666667,36.9356666666667,63.7496666666667,1.56906804869835,5.21307374475491,2.04893842757773,6.66666666666667,0,0,17.2694503890811,24.6041666666667,24.6041666666667,0.000655045160745414,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95666666666667,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415640,17,1,1006.43525,957.000106867861,1009.46481692923,26.161914596703,28.9844,24.59375,36.942125,63.856125,1.32573932855416,21.2132518908435,1.89132777930252,37.3737373737374,0,0,17.2860325515588,24.59375,24.59375,0.00065027362442455,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415700,17,1,1006.52566666667,957.085983779973,1009.55450921323,26.1798457364125,28.9270666666667,24.5625,36.9398333333333,63.9587,1.25306978215498,13.088857120041,1.52400378910741,8.28282828282828,0,0,17.2819176706824,24.5625,24.5625,0.000648321939245828,22.6279666666667,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95333333333333,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415760,17,1,1006.598,957.155948589116,1009.62758239637,26.2781592033165,29.007825,24.59375,37.02085,64.0448,1.18709588893031,8.68224678038146,1.76463596633489,13.1313131313131,0,0,17.3327696604249,24.59375,24.59375,0.000644078176539348,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.9525,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415820,17,1,1006.598,957.155614902655,1009.6272338851,26.2577810936585,28.9687666666667,24.5625,36.9423666666667,64.1062333333333,1.16313474373605,9.69193965441249,1.41563018632643,9.8989898989899,0,0,17.3184140279377,24.5625,24.5625,0.000639681327518622,22.6279666666667,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95333333333333,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415880,17,1,1006.52566666667,957.175679326426,1009.64818971657,26.2890357860605,29.0000333333333,24.5625,37.0514333333333,64.3225,1.14985682712548,15.0370934178421,1.52400378910741,22.020202020202,0,0,17.3717807132265,24.5625,24.5625,0.000638087368965944,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519415940,17,1,1006.54375,957.193101012798,1009.66638539809,26.2230418179688,29.0469,24.484375,37.187,64.662875,1.13825413437174,16.0048287423882,1.31196847931855,13.1313131313131,0,0,17.3815066164511,24.484375,24.484375,0.000633605917919363,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.955,4.93,NULL,20228790,NULL,1232,1384);
INSERT INTO `archive` VALUES (1519416000,17,1,1006.45333333333,957.106362867904,1009.57579370126,25.8155385231676,29.0208666666667,24.4791666666667,37.1648,64.5504666666667,1.69383267138936,9.63875369499824,2.41166915399102,6.66666666666667,0,0,17.3490030269153,24.4791666666667,24.4791666666667,0.000622694587762448,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95333333333333,4.93,NULL,20228790,NULL,1232,1384);
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-02-24  7:01:14
    Back to top

Extract from the mesoraw Database dump file:

mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1519328774"  --single-transaction --skip-opt


-- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for debian-linux-gnu (i686)
--
-- Host: localhost    Database: mesoraw
-- ------------------------------------------------------
-- Server version	10.1.26-MariaDB-0+deb9u1
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `archive`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `archive` (
  `dateTime` int(11) NOT NULL,
  `usUnits` int(11) NOT NULL,
  `barometer` double DEFAULT NULL,
  `pressure` double DEFAULT NULL,
  `altimeter` double DEFAULT NULL,
  `inTemp` double DEFAULT NULL,
  `outTemp` double DEFAULT NULL,
  `inHumidity` double DEFAULT NULL,
  `outHumidity` double DEFAULT NULL,
  `windSpeed` double DEFAULT NULL,
  `windDir` double DEFAULT NULL,
  `windGust` double DEFAULT NULL,
  `windGustDir` double DEFAULT NULL,
  `rainRate` double DEFAULT NULL,
  `rain` double DEFAULT NULL,
  `dewpoint` double DEFAULT NULL,
  `windchill` double DEFAULT NULL,
  `heatindex` double DEFAULT NULL,
  `rxCheckPercent` double DEFAULT NULL,
  `dayET` double DEFAULT NULL,
  `radiation` double DEFAULT NULL,
  `UV` double DEFAULT NULL,
  `extraTemp1` double DEFAULT NULL,
  `extraTemp2` double DEFAULT NULL,
  `extraTemp3` double DEFAULT NULL,
  `soilTemp1` double DEFAULT NULL,
  `soilTemp2` double DEFAULT NULL,
  `soilTemp3` double DEFAULT NULL,
  `soilTemp4` double DEFAULT NULL,
  `leafTemp1` double DEFAULT NULL,
  `leafTemp2` double DEFAULT NULL,
  `extraHumid1` double DEFAULT NULL,
  `extraHumid2` double DEFAULT NULL,
  `soilMoist1` double DEFAULT NULL,
  `soilMoist2` double DEFAULT NULL,
  `soilMoist3` double DEFAULT NULL,
  `soilMoist4` double DEFAULT NULL,
  `leafWet1` double DEFAULT NULL,
  `leafWet2` double DEFAULT NULL,
  `txBatteryStatus` double DEFAULT NULL,
  `consBatteryVoltage` double DEFAULT NULL,
  `hail` double DEFAULT NULL,
  `hailRate` double DEFAULT NULL,
  `heatingTemp` double DEFAULT NULL,
  `heatingVoltage` double DEFAULT NULL,
  `supplyVoltage` double DEFAULT NULL,
  `referenceVoltage` double DEFAULT NULL,
  `windBatteryStatus` double DEFAULT NULL,
  `rainBatteryStatus` double DEFAULT NULL,
  `outTempBatteryStatus` double DEFAULT NULL,
  `inTempBatteryStatus` double DEFAULT NULL,
  PRIMARY KEY (`dateTime`),
  UNIQUE KEY `dateTime` (`dateTime`)
);
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `archive`
--
-- WHERE:  dateTime>1519328774

INSERT INTO `archive` VALUES (1519328782,17,1013.12,961.908258062825,1014.59092321903,26.0625,20.125,42.9279,85.1989,1.78816444588602,58.3838383838384,NULL,NULL,0,0,17.5570061659861,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328792,17,1013.337,962.114342301442,1014.80615427628,25.9688,20.125,42.9308,85.2103,2.12344527948965,58.3838383838384,NULL,NULL,0,0,17.5591297979148,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328810,17,1013.337,962.115823617198,1014.8077013372,25.9688,20.125,42.9367,85.5273,1.55222608149828,58.3838383838384,NULL,NULL,0,0,17.6180822566909,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328829,17,1013.12,961.908284693578,1014.59095103179,26,20.125,42.9221,85.2046,1.47052997194574,58.3838383838384,NULL,NULL,0,0,17.5580680130501,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328847,17,1013.12,961.905215433714,1014.58774554339,26.0625,20.125,42.9221,84.5477,1.55222608149828,58.3838383838384,NULL,NULL,0,0,17.4352833171078,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328859,17,1013.12,961.905162633059,1014.58769039919,26.0938,20.125,42.9308,84.5364,1.58327060312825,58.3838383838384,NULL,NULL,0,0,17.433163874858,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328877,17,1013.12,961.905242067632,1014.58777335945,26.1562,20.125,42.925,84.5534,1.42804799497842,58.3838383838384,NULL,NULL,0,0,17.4363523221758,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519328895,17,1013.12,961.90906220933,1014.59176305742,26.0312,20.1875,42.9221,85.0419,1.67640416801815,58.3838383838384,NULL,NULL,0,0,17.5889812919763,20.1875,20.1875,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328905,17,1013.12,961.908311324305,1014.59097884451,26,20.125,42.9337,85.2103,2.23520555735753,16.3636363636364,NULL,NULL,0,0,17.5591297979148,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328925,17,1013.12,961.902281918994,1014.58468182508,26.0938,20.1875,42.925,83.5964,1.84404458481996,55.1515151515151,NULL,NULL,0,0,17.3170980980044,20.1875,20.1875,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519328943,17,1013.337,962.112801689767,1014.80454528768,26.125,20.1875,42.9192,84.5534,1.30386990845856,55.1515151515151,NULL,NULL,0,0,17.4975554406019,20.1875,20.1875,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328962,17,1013.12,961.907545887902,1014.59017943437,25.9688,20.1875,42.9279,84.7186,1.88227836409055,62.4242424242424,NULL,NULL,0,0,17.52852530136,20.1875,20.1875,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519328972,17,1013.12,961.905204394965,1014.58773401469,26,20.1875,42.925,84.2194,1.67640416801815,60,NULL,NULL,0,0,17.4347786328241,20.1875,20.1875,NULL,NULL,65.8839,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519328991,17,1013.337,962.111351838706,1014.8030310879,26.0312,20.125,42.925,84.5704,2.1763843584797,60,NULL,NULL,0,0,17.4395402081706,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519329009,17,1013.337,962.112017818193,1014.80372662555,26.0938,20.125,42.9396,84.7129,1.73849321127808,60,NULL,NULL,0,0,17.466240149661,20.125,20.125,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519329027,17,1013.12,961.905257399878,1014.58778937221,26.0312,20.1875,42.9279,84.2307,1.73849321127808,63.2323232323232,NULL,NULL,0,0,17.4369060790696,20.1875,20.1875,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519329040,17,1013.12,961.906865280648,1014.58946861849,26,20.25,42.925,84.2476,1.63341944576127,63.2323232323232,NULL,NULL,0,0,17.5012626128022,20.25,20.25,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519329060,17,1013.337,962.111322909024,1014.80300087424,25.9688,20.25,42.9308,83.9136,1.78816444588602,63.2323232323232,NULL,NULL,0,0,17.4382557121012,20.25,20.25,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519329077,17,1013.337,962.112801689767,1014.80454528768,26.0938,20.1875,42.9279,84.5534,1.77501617790157,63.2323232323232,NULL,NULL,0,0,17.4975554406019,20.1875,20.1875,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519329089,17,1013.337,962.113629712509,1014.80541006053,25.9062,20.1875,42.9337,84.7299,1.95580486268784,50.3030303030303,NULL,NULL,0,0,17.5306417669667,20.1875,20.1875,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);

[...]

INSERT INTO `archive` VALUES (1519415864,17,1006.598,957.246301351176,1009.72194925677,29.0625,24.5625,36.944,64.6432,1.52400378910741,22.020202020202,NULL,NULL,0,0,17.4506291648599,24.5625,24.5625,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519415887,17,1006.381,957.038611114035,1009.5050318648,29.1875,24.5,37.2688,64.6519,1.31196847931855,13.1313131313131,NULL,NULL,0,0,17.3936057422305,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519415905,17,1006.598,957.242856966274,1009.71835184967,28.9688,24.4375,36.9415,64.5216,1.11760277867876,29.2929292929293,NULL,NULL,0,0,17.3024861336614,24.4375,24.4375,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519415915,17,1006.598,957.244179065132,1009.71973268485,28.9688,24.5,37.2714,64.5128,0.894082222943011,25.2525252525253,NULL,NULL,0,0,17.3594681444582,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519415935,17,1006.598,957.246756905751,1009.72242505006,29.0625,24.5,37.2663,64.9652,1.22936305654664,0.2020202020202,NULL,NULL,0,0,17.4702601346168,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519415954,17,1006.381,957.0377941463,1009.50417860047,29,24.5,36.944,64.5085,2.41166915399102,6.66666666666667,NULL,NULL,0,0,17.3584118217417,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519415972,17,1006.381,957.036422471437,1009.50274598425,28.9688,24.4375,37.2714,64.5085,1.73849321127808,12.3232323232323,NULL,NULL,0,0,17.2992697185717,24.4375,24.4375,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519415984,17,1006.598,957.244871985974,1009.72045638979,29.0938,24.5,37.279,64.6344,0.93133564889897,12.3232323232323,NULL,NULL,0,0,17.3893144720356,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519416005,17,1006.598,957.246781976265,1009.72245123437,28.9688,24.5,37.2739,64.9696,1.3304794984271,26.0606060606061,NULL,NULL,0,0,17.4713343654455,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.96,4.93);
INSERT INTO `archive` VALUES (1519416023,17,1006.598,957.244179065132,1009.71973268485,29.0312,24.5,37.2688,64.5128,0.869246605639039,22.8282828282828,NULL,NULL,0,0,17.3594681444582,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519416036,17,1006.598,957.240441173893,1009.71582873186,29,24.5,36.9415,63.8569,1.89132777930252,340.40404040404,NULL,NULL,0,0,17.1976248915087,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
INSERT INTO `archive` VALUES (1519416057,17,1006.381,957.038561549818,1009.50498009852,28.9688,24.5,37.2688,64.6432,1.59657539811252,34.1414141414141,NULL,NULL,0,0,17.3914724950684,24.5,24.5,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,4.95,4.95,4.95,4.93);
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-02-24  7:01:14

Back to top

Disk Usage:

    
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           379M  692K  378M   1% /run
/dev/sda1       3.7G  2.0G  1.6G  57% /
/dev/sdb1       3.7G  2.5G  975M  73% /usr
/dev/sdb2       3.7G  249M  3.2G   8% /home
/dev/sdc1       917G   21G  850G   3% /opt
tmpfs           1.5G  320M  1.2G  22% /tmp
cgroup           12K     0   12K   0% /sys/fs/cgroup

Back to top

Memory Usage:

    
              total        used        free      shared  buff/cache   available
Mem:           3.7G        495M        1.5G        328M        1.7G        2.5G
Swap:            0B          0B          0B

Back to top

Mounted File Systems:

    
sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime)
proc on /proc type proc (rw,nosuid,nodev,noexec,relatime)
udev on /dev type devtmpfs (rw,nosuid,relatime,size=1929572k,nr_inodes=209633,mode=755)
devpts on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000)
tmpfs on /run type tmpfs (rw,nosuid,noexec,relatime,size=387744k,mode=755)
/dev/sda1 on / type ext4 (rw,noatime,errors=remount-ro,data=ordered)
/dev/sdb1 on /usr type ext4 (rw,noatime,errors=remount-ro,data=ordered)
pstore on /sys/fs/pstore type pstore (rw,relatime)
/dev/sdb2 on /home type ext4 (rw,noatime,errors=remount-ro,data=ordered)
/dev/sdc1 on /opt type ext4 (rw,relatime,errors=remount-ro,data=ordered)
tmpfs on /tmp type tmpfs (rw,nosuid,nodev,relatime,size=1550968k)
rpc_pipefs on /run/rpc_pipefs type rpc_pipefs (rw,relatime)
tmpfs on /var/log type tmpfs (rw,nosuid,nodev,relatime,size=1550968k)
tmpfs on /var/lib/weewx type tmpfs (rw,nosuid,nodev,relatime,size=1550968k)
cgroup on /sys/fs/cgroup type tmpfs (rw,relatime,size=12k,mode=755)

DEBUG output

Back to top

Log snippet:

    
Feb 24 06:54:44 masterofpis weewx[15203]: reportengine: Report sqlbackup skipped due to report_timing setting
Feb 24 06:56:04 masterofpis weewx[15203]: reportengine: Running report sqlbackupweek
Feb 24 06:56:04 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
Feb 24 06:56:04 masterofpis weewx[15203]: reportengine: Report sqlbackupweek skipped due to report_timing setting
Feb 24 06:56:04 masterofpis weewx[15203]: reportengine: Running report sqlbackup
Feb 24 06:56:04 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackup/skin.conf for report sqlbackup
Feb 24 06:56:04 masterofpis weewx[15203]: reportengine: Report sqlbackup skipped due to report_timing setting
Feb 24 06:56:49 masterofpis weewx[15203]: reportengine: Running report sqlbackupweek
Feb 24 06:56:49 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
Feb 24 06:56:49 masterofpis weewx[15203]: reportengine: Report sqlbackupweek skipped due to report_timing setting
Feb 24 06:56:49 masterofpis weewx[15203]: reportengine: Running report sqlbackup
Feb 24 06:56:49 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackup/skin.conf for report sqlbackup
Feb 24 06:56:49 masterofpis weewx[15203]: reportengine: Report sqlbackup skipped due to report_timing setting
Feb 24 06:58:06 masterofpis weewx[15203]: reportengine: Running report sqlbackupweek
Feb 24 06:58:06 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
Feb 24 06:58:06 masterofpis weewx[15203]: reportengine: Report sqlbackupweek skipped due to report_timing setting
Feb 24 06:58:06 masterofpis weewx[15203]: reportengine: Running report sqlbackup
Feb 24 06:58:06 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackup/skin.conf for report sqlbackup
Feb 24 06:58:06 masterofpis weewx[15203]: reportengine: Report sqlbackup skipped due to report_timing setting
Feb 24 06:58:54 masterofpis weewx[15203]: reportengine: Running report sqlbackupweek
Feb 24 06:58:54 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
Feb 24 06:58:54 masterofpis weewx[15203]: reportengine: Report sqlbackupweek skipped due to report_timing setting
Feb 24 06:58:54 masterofpis weewx[15203]: reportengine: Running report sqlbackup
Feb 24 06:58:54 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackup/skin.conf for report sqlbackup
Feb 24 06:58:54 masterofpis weewx[15203]: reportengine: Report sqlbackup skipped due to report_timing setting
Feb 24 07:00:04 masterofpis weewx[15203]: reportengine: Running report sqlbackupweek
Feb 24 07:00:04 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
Feb 24 07:00:04 masterofpis weewx[15203]: reportengine: Report sqlbackupweek skipped due to report_timing setting
Feb 24 07:00:04 masterofpis weewx[15203]: reportengine: Running report sqlbackup
Feb 24 07:00:04 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackup/skin.conf for report sqlbackup
Feb 24 07:00:04 masterofpis weewx[15203]: reportengine: Report sqlbackup skipped due to report_timing setting
Feb 24 07:01:14 masterofpis weewx[15203]: reportengine: Running report sqlbackupweek
Feb 24 07:01:14 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
Feb 24 07:01:14 masterofpis weewx[15203]: reportengine: Report sqlbackupweek skipped due to report_timing setting
Feb 24 07:01:14 masterofpis weewx[15203]: reportengine: Running report sqlbackup
Feb 24 07:01:14 masterofpis weewx[15203]: reportengine: Found configuration file /etc/weewx/skins/sqlbackup/skin.conf for report sqlbackup
Feb 24 07:01:14 masterofpis weewx[15203]: cheetahgenerator: using search list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras', 'user.sqlbackup.SqlBackup']
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup: version is 0.3
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 1
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: starting from 2018-02-23 06:46:14
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20180224
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: processing mysql database, weatherpi
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20180224/weatherpi-host.masterofpis-201802240701-daily.gz
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: 0.17 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1519328774"  --single-transaction --skip-opt
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.05 secs
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: processing mysql database, mesoraw
Feb 24 07:01:14 masterofpis weewx[15203]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20180224/mesoraw-host.masterofpis-201802240701-daily.gz
Feb 24 07:01:15 masterofpis weewx[15203]: sqlbackup DEBUG: 0.39 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1519328774"  --single-transaction --skip-opt
Feb 24 07:01:15 masterofpis weewx[15203]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.06 secs

Back to top

MySQL files:

    
/opt/backups/mysql-backups/20180224

-rw-r--r-- 1 root 139733 Feb 24 05:40 weatherpi-host.masterofpis-201802240540-daily.gz
-rw-r--r-- 1 root 236070 Feb 24 05:40 mesoraw-host.masterofpis-201802240540-daily.gz
-rw-r--r-- 1 root 139680 Feb 24 06:01 weatherpi-host.masterofpis-201802240601-daily.gz
-rw-r--r-- 1 root 235988 Feb 24 06:01 mesoraw-host.masterofpis-201802240601-daily.gz
-rw-r--r-- 1 root 139813 Feb 24 06:20 weatherpi-host.masterofpis-201802240620-daily.gz
-rw-r--r-- 1 root 235818 Feb 24 06:20 mesoraw-host.masterofpis-201802240620-daily.gz
-rw-r--r-- 1 root 139934 Feb 24 06:40 weatherpi-host.masterofpis-201802240640-daily.gz
-rw-r--r-- 1 root 235909 Feb 24 06:40 mesoraw-host.masterofpis-201802240640-daily.gz
-rw-r--r-- 1 root 139980 Feb 24 07:01 weatherpi-host.masterofpis-201802240701-daily.gz
-rw-r--r-- 1 root 236175 Feb 24 07:01 mesoraw-host.masterofpis-201802240701-daily.gz

This station uses an OWFS to generate data. This data is then collected and displayed by weeWX, an experimental weather software system written in Python.
This skin is avaliable at github as sqlbackup