Messmate Farm, Broomfield, Victoria

26-Sep-2017 13:20

❰ Current Conditions       SqlBackup README❯

This page shows a summary of the output from the sqlbackup that last ran on Tuesday September 26, 2017 at 13:20
It started the capture from 2017-09-25 13:05:45

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>1506308745"  --single-transaction --skip-opt


-- MySQL dump 10.16  Distrib 10.1.23-MariaDB, for debian-linux-gnu (i686)
--
-- Host: localhost    Database: weatherpi
-- ------------------------------------------------------
-- Server version	10.1.23-MariaDB-9+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>1506308745

INSERT INTO `archive` VALUES (1506308760,17,1,1011.598,958.828788965379,1011.37473010062,9.23146789434118,25.234375,12.515625,35.330075,74.803725,4.0845720601712,259.7913555208,5.21547963383423,271.717171717172,0,0,8.16511078535141,12.515625,12.515625,0.0072619522695731,724.723,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506308820,17,1,1011.598,958.835011173853,1011.38122865184,9.75741096873291,25.3125,12.359375,35.010025,77.62685,3.24870415072077,255.978384294895,4.28414398493526,262.020202020202,0,0,8.56030605474309,12.359375,12.359375,0.00726906497217592,675.31,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506308880,17,1,1011.598,958.835544679496,1011.3817858517,9.26468374140418,25.304675,12.28125,35.005325,78.20245,3.85284688086181,258.553532484172,4.28414398493526,266.060606060606,0,0,8.59365444464413,12.28125,12.28125,0.00727664609410577,658.839,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506308940,17,1,1011.598,958.840176440916,1011.38662332016,9.40980761054374,25.3229333333333,12.2708333333333,35.0096,79.7936666666667,3.73395782169415,242.327895059171,4.41158991583723,253.131313131313,0,0,8.88153304542826,12.2708333333333,12.2708333333333,0.00724948753273383,636.877666666667,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309000,17,1,1011.598,958.813707806727,1011.35897915121,8.48753751163757,25.34375,12.015625,35.008825,80.619575,4.65224331283343,271.406835324824,5.3396577203541,295.151515151515,0,0,8.78550142489757,12.015625,12.015625,0.00721826134809509,642.368,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309060,17,1,1011.598,958.737249810656,1011.27912543909,7.62786294670335,25.320275,11.8125,35.096575,81.111025,5.55140160429761,268.139114717733,6.17111099531318,267.676767676768,0,0,8.67742921677281,11.8125,11.8125,0.0071810602833028,675.31,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309120,17,1,1011.598,958.839223855188,1011.38562842795,8.11358148255181,25.40625,12.015625,35.008825,80.823775,5.19995737301925,238.970192726671,6.08472623947327,246.666666666667,0,0,8.82294635405232,12.015625,12.015625,0.00709825405757614,741.194,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309180,17,1,1011.598,958.831875348737,1011.37795355749,6.71081416033744,25.39845,12.09375,35.0124,77.936875,7.15132730404566,254.597415553256,8.30219207018511,243.434343434343,0,0,8.36146009987045,12.09375,12.09375,0.00711401658674429,790.607,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309240,17,1,1011.6525,958.882928748829,1011.43127434611,7.73422379066672,25.39065,12.09375,35.01595,77.73485,5.67589728183159,243.532816421921,6.28651563006805,229.69696969697,0,0,8.32318434805674,12.09375,12.09375,0.00703816824394322,807.078,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309300,17,1,1011.74333333333,958.97403140071,1011.52642299972,8.59115723974949,25.375,12.2083333333333,35.0183333333333,78.8217,4.72716409170041,225.544111034916,5.10904127396007,220,0,0,8.63941221382862,12.2083333333333,12.2083333333333,0.00697351548403819,922.375,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309360,17,1,1011.707,958.910385603436,1011.45995060753,7.14422879768135,25.445325,12.046875,34.68925,78.2185,6.46790433502028,242.601609085234,7.34424683131759,245.858585858586,0,0,8.36916695382016,12.046875,12.046875,0.00809406086333455,905.904,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309420,17,1,1011.816,958.943456057094,1011.49448976876,8.7834290212537,25.4687333333333,11.9166666666667,34.7962,80.4236333333333,4.0407107982374,248.592846187625,4.11748392144808,252.323232323232,0,0,8.65310518657203,11.9166666666667,11.9166666666667,0.00801306065495032,856.491,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,20227963,NULL,832,984);
INSERT INTO `archive` VALUES (1506309480,17,1,1011.7615,958.918934238708,1011.46887890123,8.72088419261583,25.429675,11.921875,34.6133,81.143425,4.18657548838394,254.532533371701,4.94938373414881,260.40404040404,0,0,8.78998313319135,11.921875,11.921875,0.00794344162736654,905.904,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,20227963,NULL,832,984);

[...]

INSERT INTO `archive` VALUES (1506395340,17,1,1017.4135,964.005848116044,1016.78159476546,13.6783864762606,22.01565,15.671875,34.117275,56.807,1.89149835359719,301.439454785054,2.1731165140976,298.383838383838,0,0,7.12640577453003,15.671875,15.671875,0.0102139117305685,1696.51,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395400,17,1,1017.4135,964.009196911758,1016.78509213412,14.6446549497957,22.0625,15.765625,34.113825,52.84675,0.339951928808633,298.383838383838,1.29406637531225,298.383838383838,0,0,6.16256851446691,15.765625,15.765625,0.0101992570024456,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395460,17,1,1017.25,963.854361105013,1016.62338676485,14.724314763149,22.0547,15.78125,34.1184,52.792625,0.248356173039725,287.813394393503,0.682979475859245,283.030303030303,0,0,6.16218640111981,15.78125,15.78125,0.0102051652385634,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395520,17,1,1017.25,963.864700747309,1016.63418515019,14.5750028302875,22.1172,16.03125,34.1178,54.719,1.05551373541883,307.110916504149,1.49013703823835,310.505050505051,0,0,6.91485398757086,16.03125,16.03125,0.0102071369662067,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395580,17,1,1017.32266666667,963.926842728183,1016.69908418912,13.9205840776843,22.1354333333333,15.9375,34.1134666666667,53.2244,1.70118532124908,307.272727272727,2.29402675623536,307.272727272727,0,0,6.42499645830743,15.9375,15.9375,0.0102019308319829,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395640,17,1,1017.3045,963.908566274121,1016.67999686578,14.7481194189043,22.1094,15.9375,34.116125,52.951225,0.495720321892027,303.327532391816,0.807157562379107,297.575757575758,0,0,6.35031424481046,15.9375,15.9375,0.0102081581971579,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395700,17,1,1017.25,963.857580397863,1016.62674888945,14.9784043215223,22.08595,16.015625,34.114975,52.855675,0.292705489653962,297.575757575758,0.93133564889897,297.575757575758,0,0,6.39642625402808,16.015625,16.015625,0.0102252289380001,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395760,17,1,1017.25,963.864543333339,1016.63402075218,15.2092660729142,22.1172,16.171875,34.115575,54.07205,0.33658797135647,297.575757575758,0.372534259559588,297.575757575758,0,0,6.87212730985727,16.171875,16.171875,0.0143675529471432,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395820,17,1,1017.25,963.97945668362,1016.75403244509,16.0278073702278,22.0937333333333,16.6041666666667,34.1165,56.0583666666667,0.0916552543360891,297.575757575758,0.212876719748336,297.575757575758,0,0,7.80183368585244,16.6041666666667,16.6041666666667,0.0144243858557089,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395880,17,1,1017.25,963.992699552181,1016.76786285037,16.7537575909008,22.124975,17.0625,34.120675,57.6303,0,NULL,0,NULL,0,0,8.63708495825043,17.0625,17.0625,0.0144505647429495,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506395940,17,1,1017.25,963.975618691457,1016.75002417523,16.6032175367105,22.093775,17.359375,34.119525,52.4737333333333,0.258233975376533,297.575757575758,0.406401010428641,297.575757575758,0,0,7.53367269675148,17.359375,17.359375,0.0145302712185125,1712.98,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,20227966,NULL,834,986);
INSERT INTO `archive` VALUES (1506396000,17,1,1017.25,964.056266059479,1016.83424954493,16.207731852017,22.1458,17.3541666666667,34.1195666666667,47.8114666666667,0.379630150217866,297.575757575758,0.447041111471506,297.575757575758,0,0,6.17330101500726,17.3541666666667,17.3541666666667,0.0146154477383125,1712.98,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,20227966,NULL,834,986);
/*!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 2017-09-26 13:20:45
    Back to top

Extract from the mesoraw Database dump file:

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


-- MySQL dump 10.16  Distrib 10.1.23-MariaDB, for debian-linux-gnu (i686)
--
-- Host: localhost    Database: mesoraw
-- ------------------------------------------------------
-- Server version	10.1.23-MariaDB-9+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>1506308745

INSERT INTO `archive` VALUES (1506308749,17,1011.598,958.829191873423,1011.37515090276,25.2812,12.375,35.3289,75.6276,3.35280833603629,253.131313131313,NULL,NULL,0,0,8.19055792174241,12.375,12.375,NULL,NULL,724.723,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 (1506308768,17,1011.598,958.833486423359,1011.37963618367,25.2812,12.375,35.0112,77.0439,2.70577514838017,231.313131313131,NULL,NULL,0,0,8.46413824239355,12.375,12.375,NULL,NULL,724.723,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 (1506308786,17,1011.598,958.835845368048,1011.38209989452,25.375,12.4375,35.0065,77.5035,4.28414398493526,262.020202020202,NULL,NULL,0,0,8.61256958730556,12.4375,12.4375,NULL,NULL,658.839,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 (1506308793,17,1011.598,958.835858541889,1011.38211365344,25.25,12.375,35.0159,77.8263,2.71417817679128,257.171717171717,NULL,NULL,0,0,8.61337848248908,12.375,12.375,NULL,NULL,658.839,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 (1506308811,17,1011.598,958.834854362114,1011.38106487573,25.3438,12.25,35.0065,78.1337,3.29071929277636,266.868686868687,NULL,NULL,0,0,8.55032688859625,12.25,12.25,NULL,NULL,658.839,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 (1506308832,17,1011.598,958.836270342819,1011.38254374339,25.3125,12.25,35.0018,78.6046,3.83178095547005,241.010101010101,NULL,NULL,0,0,8.63911882773678,12.25,12.25,NULL,NULL,658.839,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 (1506308850,17,1011.598,958.835804986023,1011.38205771903,25.3125,12.3125,35.0065,78.1285,4.28414398493526,266.060606060606,NULL,NULL,0,0,8.61000653872979,12.3125,12.3125,NULL,NULL,658.839,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 (1506308858,17,1011.598,958.836266030111,1011.38253923914,25.3125,12.3125,35.0065,78.2812,3.63220903070598,262.828282828283,NULL,NULL,0,0,8.63886671393143,12.3125,12.3125,NULL,NULL,658.839,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 (1506308876,17,1011.598,958.833837359031,1011.3800027052,25.2812,12.25,35.0065,77.7955,3.66325355233595,263.636363636364,NULL,NULL,0,0,8.48626555931553,12.25,12.25,NULL,NULL,658.839,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 (1506308894,17,1011.598,958.836161192624,1011.38242974558,25.3125,12.25,35.0112,78.5683,3.53907546581609,218.383838383838,NULL,NULL,0,0,8.63229084881075,12.25,12.25,NULL,NULL,658.839,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 (1506308913,17,1011.598,958.84245266167,1011.38900063298,25.3438,12.3125,35.0088,80.3305,4.41158991583723,253.131313131313,NULL,NULL,0,0,9.02146483967145,12.3125,12.3125,NULL,NULL,592.955,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 (1506308924,17,1011.598,958.841915468454,1011.38843958181,25.3125,12.25,35.0088,80.4822,3.25120808342913,253.131313131313,NULL,NULL,0,0,8.98856474835122,12.25,12.25,NULL,NULL,658.839,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 (1506308942,17,1011.598,958.837574167996,1011.38390547441,25.375,12.125,35.0041,79.6902,3.72534259559588,276.565656565657,NULL,NULL,0,0,8.72043180560376,12.125,12.125,NULL,NULL,592.955,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 (1506308960,17,1011.598,958.839848590916,1011.38628090961,25.25,12.0625,35.0088,80.7843,4.59458920123492,236.161616161616,NULL,NULL,0,0,8.86139542320105,12.0625,12.0625,NULL,NULL,658.839,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 (1506308967,17,1011.598,958.839305259456,1011.38571344757,25.375,12,35.0136,80.9335,4.94938373414881,273.333333333333,NULL,NULL,0,0,8.82780216630067,12,12,NULL,NULL,658.839,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 (1506308985,17,1011.598,958.73810320854,1011.28001673908,25.375,11.875,35.0088,81.0703,5.3396577203541,295.151515151515,NULL,NULL,0,0,8.73093857671928,11.875,11.875,NULL,NULL,658.839,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 (1506309003,17,1011.598,958.736564558506,1011.27840975272,25.2812,11.8125,35.3432,80.8802,6.02263719621334,286.262626262626,NULL,NULL,0,0,8.63529570217412,11.8125,11.8125,NULL,NULL,658.839,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 (1506309026,17,1011.598,958.734163570699,1011.27590212938,25.4062,11.75,35.0112,80.3921,6.17111099531318,267.676767676768,NULL,NULL,0,0,8.48497665000422,11.75,11.75,NULL,NULL,658.839,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 (1506309034,17,1011.598,958.736947836116,1011.2788100529,25.2812,11.75,35.0183,81.3454,5.16891285138929,266.868686868687,NULL,NULL,0,0,8.65914233934782,11.75,11.75,NULL,NULL,658.839,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 (1506309052,17,1011.598,958.741323277305,1011.28337982125,25.3125,11.9375,35.0136,81.8264,4.84294537427465,247.474747474747,NULL,NULL,0,0,8.92934928617153,11.9375,11.9375,NULL,NULL,724.723,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 (1506395850,17,1017.25,963.995341082839,1016.77062157571,22.1562,17.125,34.1241,58.0435,0,NULL,NULL,NULL,0,0,8.80122193598647,17.125,17.125,NULL,NULL,1712.98,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 (1506395869,17,1017.25,963.999973948104,1016.77545998347,22.125,17.25,34.1195,58.6887,0,NULL,NULL,NULL,0,0,9.08207833927532,17.25,17.25,NULL,NULL,1712.98,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 (1506395887,17,1017.25,NULL,NULL,22.125,17.3125,34.1241,NULL,0,NULL,NULL,NULL,0,0,NULL,17.3125,NULL,NULL,NULL,1712.98,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 (1506395909,17,1017.25,963.974757544281,1016.74912482208,22.0625,17.375,34.1195,52.2781,0.254000631517901,297.575757575758,NULL,NULL,0,0,7.49340221990875,17.375,17.375,NULL,NULL,1712.98,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 (1506395920,17,1017.25,963.989379268292,1016.76439525801,22.0938,17.4375,34.115,55.5076,0.406401010428641,297.575757575758,NULL,NULL,0,0,8.43259309572688,17.4375,17.4375,NULL,NULL,1712.98,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 (1506395938,17,1017.25,963.962719261799,1016.73655244401,22.0938,17.3125,34.1195,49.6355,0.372534259559588,297.575757575758,NULL,NULL,0,0,6.67868688668723,17.3125,17.3125,NULL,NULL,1712.98,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 (1506395956,17,1017.25,964.050298094654,1016.82801680733,22.125,17.3125,34.115,46.5206,0.372534259559588,297.575757575758,NULL,NULL,0,0,5.73943519413528,17.3125,17.3125,NULL,NULL,1712.98,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 (1506395963,17,1017.25,964.057338406036,1016.83536946684,22.1562,17.4375,34.1173,47.8135,0.319315079622504,297.575757575758,NULL,NULL,0,0,6.25010371490339,17.4375,17.4375,NULL,NULL,1712.98,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 (1506395983,17,1017.25,964.061161677749,1016.83936236037,22.1562,17.3125,34.1264,49.1003,0.447041111471506,297.575757575758,NULL,NULL,0,0,6.52107076274318,17.3125,17.3125,NULL,NULL,1712.98,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 (1506396001,17,1017.25,963.946139422403,1016.71923701426,22.0625,17.25,34.1241,45.8942,0.620890432599313,297.575757575758,NULL,NULL,0,0,5.48701991183959,17.25,17.25,NULL,NULL,1712.98,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 (1506396020,17,1017.25,963.948777615396,1016.72199225496,22.125,17.25,34.1173,46.5206,1.41170877306791,320.20202020202,NULL,NULL,0,0,5.68247863121926,17.25,17.25,NULL,NULL,1712.98,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 (1506396029,17,1017.25,963.954561436749,1016.72803268468,22.1562,17.25,34.1264,47.8941,0.993424692158901,320.20202020202,NULL,NULL,0,0,6.10306639673815,17.25,17.25,NULL,NULL,1712.98,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);
/*!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 2017-09-26 13:20:45

Back to top

Disk Usage:

    
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           379M  656K  379M   1% /run
/dev/sda1       3.7G  2.8G  761M  79% /
/dev/sdb1       917G   16G  855G   2% /opt
tmpfs           1.5G  459M  1.1G  31% /tmp

Back to top

Memory Usage:

    
              total        used        free      shared  buff/cache   available
Mem:           3.7G        639M        937M        466M        2.2G        2.2G
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=1929724k,nr_inodes=209709,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=387772k,mode=755)
/dev/sda1 on / type ext4 (rw,noatime,errors=remount-ro,data=ordered)
pstore on /sys/fs/pstore type pstore (rw,relatime)
/dev/sdb1 on /opt type ext4 (rw,relatime,errors=remount-ro,data=ordered)
tmpfs on /tmp type tmpfs (rw,nosuid,nodev,relatime,size=1551088k)
rpc_pipefs on /run/rpc_pipefs type rpc_pipefs (rw,relatime)
tmpfs on /var/log type tmpfs (rw,nosuid,nodev,relatime,size=1551088k)
tmpfs on /var/lib/weewx type tmpfs (rw,nosuid,nodev,relatime,size=1551088k)

DEBUG output

Back to top

Log snippet:

    
Sep 26 12:20:49 masterofpis OWFS[22094]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Sep 26 12:20:49 masterofpis OWFS[22094]: cheetahgenerator: Generated 1 files for report sqlbackup in 1.21 seconds
Sep 26 12:20:49 masterofpis OWFS[22094]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup: version is 0.3
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup DEBUG: starting from 2017-09-25 12:25:41
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20170926
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup DEBUG: processing mysql database, weatherpi
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170926/weatherpi-host.masterofpis-201709261240-daily.gz
Sep 26 12:40:41 masterofpis OWFS[22094]: sqlbackup DEBUG: 0.20 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1506306341"  --single-transaction --skip-opt
Sep 26 12:40:42 masterofpis OWFS[22094]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.09 secs
Sep 26 12:40:42 masterofpis OWFS[22094]: sqlbackup DEBUG: processing mysql database, mesoraw
Sep 26 12:40:42 masterofpis OWFS[22094]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170926/mesoraw-host.masterofpis-201709261240-daily.gz
Sep 26 12:40:42 masterofpis OWFS[22094]: sqlbackup DEBUG: 0.41 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1506306341"  --single-transaction --skip-opt
Sep 26 12:40:42 masterofpis OWFS[22094]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.12 secs
Sep 26 12:40:42 masterofpis OWFS[22094]: sqlbackup: Total time used in backups and report output: 0.97 seconds
Sep 26 12:40:42 masterofpis OWFS[22094]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Sep 26 12:40:42 masterofpis OWFS[22094]: cheetahgenerator: Generated 1 files for report sqlbackup in 1.26 seconds
Sep 26 12:40:42 masterofpis OWFS[22094]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup: version is 0.3
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: starting from 2017-09-25 12:46:10
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20170926
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: processing mysql database, weatherpi
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170926/weatherpi-host.masterofpis-201709261301-daily.gz
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: 0.19 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1506307570"  --single-transaction --skip-opt
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.09 secs
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: processing mysql database, mesoraw
Sep 26 13:01:10 masterofpis OWFS[22094]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170926/mesoraw-host.masterofpis-201709261301-daily.gz
Sep 26 13:01:11 masterofpis OWFS[22094]: sqlbackup DEBUG: 0.42 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1506307570"  --single-transaction --skip-opt
Sep 26 13:01:11 masterofpis OWFS[22094]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.10 secs
Sep 26 13:01:11 masterofpis OWFS[22094]: sqlbackup: Total time used in backups and report output: 0.93 seconds
Sep 26 13:01:11 masterofpis OWFS[22094]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Sep 26 13:01:11 masterofpis OWFS[22094]: cheetahgenerator: Generated 1 files for report sqlbackup in 1.22 seconds
Sep 26 13:01:11 masterofpis OWFS[22094]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup: version is 0.3
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: starting from 2017-09-25 13:05:45
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20170926
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: processing mysql database, weatherpi
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170926/weatherpi-host.masterofpis-201709261320-daily.gz
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: 0.18 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1506308745"  --single-transaction --skip-opt
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.09 secs
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: processing mysql database, mesoraw
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170926/mesoraw-host.masterofpis-201709261320-daily.gz
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: 0.41 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1506308745"  --single-transaction --skip-opt
Sep 26 13:20:45 masterofpis OWFS[22094]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.10 secs

Back to top

MySQL files:

    
/opt/backups/mysql-backups/20170926

-rw-r--r-- 1 root 126555 Sep 26 12:01 weatherpi-host.masterofpis-201709261201-daily.gz
-rw-r--r-- 1 root 215109 Sep 26 12:01 mesoraw-host.masterofpis-201709261201-daily.gz
-rw-r--r-- 1 root 126372 Sep 26 12:20 weatherpi-host.masterofpis-201709261220-daily.gz
-rw-r--r-- 1 root 214419 Sep 26 12:20 mesoraw-host.masterofpis-201709261220-daily.gz
-rw-r--r-- 1 root 126131 Sep 26 12:40 weatherpi-host.masterofpis-201709261240-daily.gz
-rw-r--r-- 1 root 213867 Sep 26 12:40 mesoraw-host.masterofpis-201709261240-daily.gz
-rw-r--r-- 1 root 126019 Sep 26 13:01 weatherpi-host.masterofpis-201709261301-daily.gz
-rw-r--r-- 1 root 213818 Sep 26 13:01 mesoraw-host.masterofpis-201709261301-daily.gz
-rw-r--r-- 1 root 125956 Sep 26 13:20 weatherpi-host.masterofpis-201709261320-daily.gz
-rw-r--r-- 1 root 213370 Sep 26 13:20 mesoraw-host.masterofpis-201709261320-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