Messmate Farm, Broomfield, Victoria

21-Jul-2017 17:20

❰ Current Conditions       SqlBackup README❯

This page shows a summary of the output from the sqlbackup that last ran on Friday July 21, 2017 at 17:20
It started the capture from 2017-07-20 17:05:50
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>1500534350"  --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>1500534350

INSERT INTO `archive` VALUES (1500534360,17,1,1020.729,966.652224456697,1019.5453493429,5.7321745398428,23.02345,8.5,34.831875,80.61885,2.45170024767176,170.250431841914,3.41489737929622,152.121212121212,0,0,5.35948557019495,7.08182704253013,8.5,0.0015339009636306,1054.14,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534420,17,1,1020.729,966.660201125294,1019.55367971717,5.52728348849449,22.9896,8.5625,34.8332666666667,80.0152,2.81987738138855,167.244030842095,4.22205494167533,163.434343434343,0,0,5.31223084418423,6.90010883289998,8.5625,0.00129918227786477,1054.14,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534480,17,1,1020.729,966.623599922844,1019.51545552011,5.12664563082396,22.9922,8.4375,34.834825,79.821425,3.16817512844755,180.004163735485,3.41489737929622,165.050505050505,0,0,5.15566698795407,6.53211543629863,8.4375,0.00105971393586071,1054.14,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534540,17,1,1020.729,966.624678471023,1019.51658189415,4.88805901517878,22.929675,8.40625,34.75345,80.435925,3.48748677546041,175.873797159807,3.78743163885581,186.868686868687,0,0,5.23544919726147,6.31084383597508,8.40625,0.000814134429149762,1021.19875,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534600,17,1,1020.729,966.625348109425,1019.5172812262,5.23446789163218,22.97655,8.515625,34.830125,80.117575,3.1632733618744,192.088237885404,3.58809313154761,203.838383838384,0,0,5.28497349302924,6.6292791390826,8.515625,0.000564133590929381,955.317,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534660,17,1,1020.729,966.728476394599,1019.62498246162,5.18401814419257,22.9792,8.41666666666667,34.5077333333333,80.5241,3.08709878248472,182.796424646398,4.05866272257025,186.868686868687,0,0,5.26135285976897,6.55603687911558,8.41666666666667,0.000305245677563282,527.071666666667,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534720,17,1,1020.729,966.620719886402,1019.51244777469,4.92900745246205,22.96095,7.984375,34.5866,81.09325,2.74156482546418,170.750591615743,3.45440858864345,179.59595959596,0,0,4.94103598339465,6.26237066853995,7.984375,0.0000460640510864989,774.136,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534780,17,1,1020.729,966.621331962552,1019.51308699204,4.4263152263846,22.9270666666667,7.9375,34.5031,81.6107333333333,3.40573185386262,183.153399823828,4.15109603509255,179.59595959596,0,0,4.98654467827138,5.78781079649314,7.9375,0,746.684333333333,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.95333333333333,4.95,4.95,4.93,NULL,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534840,17,1,1020.729,966.621126904205,1019.51287284082,4.69325582167914,22.9531,7.890625,34.66565,81.7832,2.95299924675895,180.515468408362,3.29692819710235,181.212121212121,0,0,4.97106933624902,6.00847411717497,7.890625,0,280.007,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534900,17,1,1020.729,966.622881433321,1019.51470517074,4.71646373658669,22.9167,7.875,34.5054,82.621,2.9351184086513,186.989547982283,3.40360846233987,202.222222222222,0,0,5.10209289202761,6.00141377933771,7.875,0,153.729333333333,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500534960,17,1,1020.8375,966.725171307888,1019.62153082107,4.90342444389501,22.992175,7.703125,34.67035,83.3944,2.41261827055788,173.909913333774,2.82341754613583,176.363636363636,0,0,5.06776958077549,6.16951780896752,7.703125,0,131.768,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500535020,17,1,1020.8375,966.724308262856,1019.62062950696,4.39915695795014,22.90625,7.53125,34.664475,83.998925,2.86892836830761,180.849810827622,3.15844263539651,179.59595959596,0,0,5.00316312308225,5.63369799799895,7.53125,0,214.123,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500535080,17,1,1020.946,966.827690679099,1019.72859605129,5.26988542156823,22.921875,7.609375,34.668575,83.829025,1.75024578018085,182.828282828283,1.91589047773502,182.828282828283,0,0,5.05061771250077,6.64929105201615,7.609375,0,197.652,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,20227337,NULL,522,674);

[...]

INSERT INTO `archive` VALUES (1500620940,17,1,1021.381,967.248503155985,1020.16806699235,9.85955556715156,24.6666666666667,11.3541666666667,32.6714666666667,68.1935333333333,0.733833358910236,45.7417021291295,0.79828769905626,45.4545454545455,0,0,5.70102563690709,11.3541666666667,11.3541666666667,0.000304940352589873,1010.21833333333,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621000,17,1,1021.381,967.246321905638,1020.16578903129,9.98046392056792,24.585925,11.171875,32.747825,68.275825,0.254074900708403,45.4545454545455,0.705854386533956,45.4545454545455,0,0,5.54429398113229,11.171875,11.171875,0,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.95,4.93,NULL,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621060,17,1,1021.381,967.246944426516,1020.16643915305,10.1832487567803,24.63285,11.1875,32.66615,68.417725,0,NULL,0,NULL,0,0,5.58915226640735,11.1875,11.1875,0,938.846,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621120,17,1,1021.43525,967.298979413687,1020.22078121849,9.96974466527396,24.60155,11.203125,32.67165,68.5731,0.341489737929622,45.4545454545455,0.620890432599313,45.4545454545455,0,0,5.63679787598804,11.203125,11.203125,0,1004.72925,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621180,17,1,1021.381,967.247841804124,1020.16737631795,9.93472218103735,24.601575,11.171875,32.66945,68.796475,0.351954048432602,45.4545454545455,0.591672059300522,45.4545454545455,0,0,5.65383772975911,11.171875,11.171875,0,938.846,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621240,17,1,1021.43525,967.297824006441,1020.21957458414,9.98834056149919,24.6172,11,32.5878,69.1025,0,NULL,0,NULL,0,0,5.55345747734112,11,11,0,658.83925,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621300,17,1,1021.52566666667,967.383233726186,1020.30877106843,9.79759332363903,24.6041666666667,10.8125,32.6670666666667,69.8924333333333,0,NULL,0,NULL,0,0,5.53778676910877,10.8125,10.8125,0,351.381333333333,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621360,17,1,1021.4895,967.346721181223,1020.27063969443,9.43556333474664,24.609375,10.484375,32.915575,70.62425,0,NULL,0,NULL,0,0,5.37326228437242,10.484375,10.484375,0,230.594,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621420,17,1,1021.52566666667,967.311085618484,1020.23342417335,9.13595040046338,24.6250333333333,10.2083333333333,32.8900333333333,71.7156,0.0206963477533104,45.4545454545455,0.0620890432599313,45.4545454545455,0,0,5.32889992568468,10.2083333333333,10.2083333333333,0,219.613333333333,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621480,17,1,1021.43525,967.19049816673,1020.107490205,8.66161750058743,24.624975,10.046875,32.9945,72.372425,0.460628129379685,45.4545454545455,0.79828769905626,45.4545454545455,0,0,5.30481049578716,10.046875,10.046875,0,263.536,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621540,17,1,1021.598,967.344857365946,1020.26869324427,8.27261227312244,24.6328,9.875,33.08005,73.3022,0.776113040749142,45.6646439905318,0.869246605639039,45.4545454545455,0,0,5.32296637075346,9.875,9.875,0,345.891,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,20227337,NULL,522,674);
INSERT INTO `archive` VALUES (1500621600,17,1,1021.598,967.397243373022,1020.32340184723,8.10855132755,24.601575,9.703125,33.158925,74.30935,0.77389557491843,45.8597435866705,0.869246605639039,46.2626262626263,0,0,5.35357106386473,9.703125,9.703125,0,395.304,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,20227337,NULL,522,674);
/*!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-07-21 17:20:50
    Back to top

Extract from the mesoraw Database dump file: 

mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1500534350"  --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>1500534350

INSERT INTO `archive` VALUES (1500534357,17,1020.729,966.731290252431,1019.62792109119,23,8.625,34.8301,80.5451,1.86267129779794,185.252525252525,NULL,NULL,0,0,5.46813236723062,7.71387287252456,8.625,NULL,NULL,1054.14,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 (1500534378,17,1020.729,966.730516077063,1019.62711258744,23,8.625,34.8372,80.2293,1.86267129779794,169.89898989899,NULL,NULL,0,0,5.41155841367296,7.71387287252456,8.625,NULL,NULL,1054.14,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 (1500534386,17,1020.729,966.626216447891,1019.51818806923,22.9688,8.5625,34.8301,80.2188,2.37490590469237,171.935483870968,NULL,NULL,0,0,5.34879482005024,7.21310996472543,8.5625,NULL,NULL,1054.14,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 (1500534404,17,1020.729,966.623870850927,1019.51573846191,23,8.5,34.8325,79.5975,4.22205494167533,163.434343434343,NULL,NULL,0,0,5.17613615092204,6.0526064710061,8.5,NULL,NULL,1054.14,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 (1500534423,17,1020.729,966.626267910621,1019.51824181396,22.9375,8.5625,34.8325,80.2398,3.23516593828063,193.709677419355,NULL,NULL,0,0,5.35256149764918,6.64345270719966,8.5625,NULL,NULL,1054.14,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 (1500534441,17,1020.729,966.622208812983,1019.51400272451,22.9688,8.375,34.8348,79.5871,3.22863024951643,179.59595959596,NULL,NULL,0,0,5.0526119629646,6.420757561919,8.375,NULL,NULL,1054.14,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 (1500534449,17,1020.729,966.62297507663,1019.51480296645,23.0625,8.4375,34.8348,79.5663,2.79400694669691,182.828282828283,NULL,NULL,0,0,5.10968145390751,6.76779781971172,8.4375,NULL,NULL,1054.14,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 (1500534467,17,1020.729,966.622947891141,1019.51477457548,23,8.375,34.8372,79.8925,3.41489737929622,165.050505050505,NULL,NULL,0,0,5.10760391006344,6.31338367188589,8.375,NULL,NULL,1054.14,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 (1500534484,17,1020.729,966.622866715652,1019.51468980044,22.9375,8.3125,34.8418,80.1978,3.55003235580313,146.464646464646,NULL,NULL,0,0,5.1015139761937,6.16245817333632,8.3125,NULL,NULL,1054.14,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 (1500534502,17,1020.729,966.62442526094,1019.51631745602,22.875,8.375,34.8325,80.503,3.78743163885581,186.868686868687,NULL,NULL,0,0,5.21698045979867,6.11262328974313,8.375,NULL,NULL,1054.14,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 (1500534510,17,1020.729,966.625289801015,1019.51722033224,23,8.4375,34.8325,80.5188,3.63220903070598,174.747474747475,NULL,NULL,0,0,5.28070876504919,6.27036562121202,8.4375,NULL,NULL,1054.14,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 (1500534528,17,1020.729,966.626132106486,1019.51809998789,22.9062,8.5,34.507,80.5241,2.9802740764767,197.373737373737,NULL,NULL,0,0,5.34256280433802,6.72240311086264,8.5,NULL,NULL,922.375,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 (1500534546,17,1020.729,966.625348522054,1019.51728165713,23.0312,8.5,34.8301,80.203,2.66982886017705,203.838383838384,NULL,NULL,0,0,5.28508208451065,6.92629668216496,8.5,NULL,NULL,988.259,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 (1500534564,17,1020.729,966.626925889753,1019.51892896973,23.0625,8.5625,34.8255,80.5083,3.29071929277636,207.070707070707,NULL,NULL,0,0,5.40064472777825,6.61125077588031,8.5625,NULL,NULL,988.259,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 (1500534573,17,1020.729,966.626119173013,1019.51808648091,22.9375,8.5,34.8348,80.5188,3.10445216299657,148.888888888889,NULL,NULL,0,0,5.34161568273367,6.64581932636273,8.5,NULL,NULL,922.375,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 (1500534592,17,1020.729,966.62299885288,1019.51482779701,22.875,8.5,34.8301,79.2402,3.58809313154761,203.838383838384,NULL,NULL,0,0,5.1115048732942,6.37013020703753,8.5,NULL,NULL,922.375,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 (1500534611,17,1020.729,966.728750795907,1019.6252690304,22.9688,8.4375,34.5116,80.5241,4.05866272257025,186.868686868687,NULL,NULL,0,0,5.28165541200938,6.05352159153915,8.4375,NULL,NULL,922.375,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 (1500534640,17,1020.729,966.728750795907,1019.6252690304,23,8.4375,34.5046,80.5241,2.96742806752637,174.747474747475,NULL,NULL,0,0,5.28165541200938,6.6554645801096,8.4375,NULL,NULL,395.304,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 (1500534648,17,1020.729,966.727927591984,1019.62440932406,22.9688,8.375,34.507,80.5241,2.23520555735753,186.060606060606,NULL,NULL,0,0,5.22074762309101,7.10133357875478,8.375,NULL,NULL,263.536,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 (1500534667,17,1020.729,966.620302739823,1019.51201213065,23,8.0625,34.8301,80.4872,2.47049035286885,120.606060606061,NULL,NULL,0,0,4.90963059670379,6.55021009803266,8.0625,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 (1500621469,17,1021.381,967.13895729519,1020.05366411334,24.625,9.9375,32.9945,72.8392,0.434623302819519,45.4545454545455,NULL,NULL,0,0,5.29201625791332,9.9375,9.9375,NULL,NULL,263.536,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 (1500621487,17,1021.598,967.345301449138,1020.26915701652,24.625,9.9375,33.0012,73.1607,0.558801389339382,45.4545454545455,NULL,NULL,0,0,5.35537912772378,9.9375,9.9375,NULL,NULL,263.536,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 (1500621505,17,1021.598,967.344412338275,1020.26822848567,24.6562,9.875,32.9967,73.1367,0.807157562379107,46.2626262626263,NULL,NULL,0,0,5.29045114853722,9.875,9.875,NULL,NULL,329.42,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 (1500621514,17,1021.598,967.3452638173,1020.26911771623,24.5625,9.875,32.9989,73.4533,0.869246605639039,45.4545454545455,NULL,NULL,0,0,5.35259600492749,9.875,9.875,NULL,NULL,395.304,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 (1500621532,17,1021.598,967.34445185907,1020.26826975867,24.6875,9.8125,33.3234,73.4581,0.869246605639039,45.4545454545455,NULL,NULL,0,0,5.29329812175571,9.8125,9.8125,NULL,NULL,395.304,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 (1500621550,17,1021.598,967.450064076111,1020.37856439431,24.5938,9.75,32.9967,74.3983,0.682979475859245,46.2626262626263,NULL,NULL,0,0,5.4160355475261,9.75,9.75,NULL,NULL,395.304,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 (1500621568,17,1021.598,967.449209934377,1020.37767238379,24.5938,9.75,33.3144,74.0768,0.869246605639039,46.2626262626263,NULL,NULL,0,0,5.35369762231786,9.75,9.75,NULL,NULL,395.304,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 (1500621575,17,1021.598,967.345269249581,1020.26912338935,24.6562,9.6875,33.3234,74.3836,0.79828769905626,45.4545454545455,NULL,NULL,0,0,5.35286173136034,9.6875,9.6875,NULL,NULL,395.304,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 (1500621593,17,1021.598,967.344430232018,1020.26824717276,24.5625,9.625,33.0012,74.3787,0.745068519119176,45.4545454545455,NULL,NULL,0,0,5.29158494682573,9.625,9.625,NULL,NULL,395.304,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 (1500621611,17,1021.598,967.34354182298,1020.26731937483,24.5625,9.625,32.9967,74.0428,0.682979475859245,45.4545454545455,NULL,NULL,0,0,5.22649880473675,9.625,9.625,NULL,NULL,329.42,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 (1500621629,17,1021.598,967.34437658281,1020.26819114493,24.625,9.5625,32.9989,74.6708,0.807157562379107,45.4545454545455,NULL,NULL,0,0,5.28761649362264,9.5625,9.5625,NULL,NULL,329.42,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 (1500621636,17,1021.598,967.344396115563,1020.2682115437,24.5938,9.5,32.9967,74.9921,0.957945238867512,45.4545454545455,NULL,NULL,0,0,5.28899893126239,9.5,9.5,NULL,NULL,263.536,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 2017-07-21 17:20:51
Back to top

Disk Usage:

     
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           379M  652K  379M   1% /run
/dev/sda1       3.7G  2.7G  897M  75% /
/dev/sdb1       917G   14G  857G   2% /opt
tmpfs           1.5G  892M  624M  59% /tmp
Back to top

Memory Usage:

     
              total        used        free      shared  buff/cache   available
Mem:           3.7G        479M        451M        899M        2.8G        2.0G
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:

     
Jul 21 16:20:48 masterofpis OWFS[29481]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Jul 21 16:20:48 masterofpis OWFS[29481]: cheetahgenerator: Generated 1 files for report sqlbackup in 1.05 seconds
Jul 21 16:20:48 masterofpis OWFS[29481]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup: version is 0.3
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: starting from 2017-07-20 16:25:50
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20170721
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: processing mysql database, weatherpi
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170721/weatherpi-host.masterofpis-201707211640-daily.gz
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: 0.18 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1500531950"  --single-transaction --skip-opt
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.05 secs
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: processing mysql database, mesoraw
Jul 21 16:40:50 masterofpis OWFS[21511]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170721/mesoraw-host.masterofpis-201707211640-daily.gz
Jul 21 16:40:51 masterofpis OWFS[21511]: sqlbackup DEBUG: 0.39 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1500531950"  --single-transaction --skip-opt
Jul 21 16:40:51 masterofpis OWFS[21511]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.05 secs
Jul 21 16:40:51 masterofpis OWFS[21511]: sqlbackup: Total time used in backups and report output: 0.76 seconds
Jul 21 16:40:51 masterofpis OWFS[21511]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Jul 21 16:40:51 masterofpis OWFS[21511]: cheetahgenerator: Generated 1 files for report sqlbackup in 1.08 seconds
Jul 21 16:40:51 masterofpis OWFS[21511]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup: version is 0.3
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: starting from 2017-07-20 16:46:06
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20170721
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: processing mysql database, weatherpi
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170721/weatherpi-host.masterofpis-201707211701-daily.gz
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: 0.16 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1500533166"  --single-transaction --skip-opt
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.05 secs
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: processing mysql database, mesoraw
Jul 21 17:01:06 masterofpis OWFS[21511]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170721/mesoraw-host.masterofpis-201707211701-daily.gz
Jul 21 17:01:07 masterofpis OWFS[21511]: sqlbackup DEBUG: 0.39 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1500533166"  --single-transaction --skip-opt
Jul 21 17:01:07 masterofpis OWFS[21511]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.06 secs
Jul 21 17:01:07 masterofpis OWFS[21511]: sqlbackup: Total time used in backups and report output: 0.76 seconds
Jul 21 17:01:07 masterofpis OWFS[21511]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Jul 21 17:01:07 masterofpis OWFS[21511]: cheetahgenerator: Generated 1 files for report sqlbackup in 1.05 seconds
Jul 21 17:01:07 masterofpis OWFS[21511]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Jul 21 17:20:50 masterofpis OWFS[21511]: sqlbackup: version is 0.3
Jul 21 17:20:50 masterofpis OWFS[21511]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Jul 21 17:20:50 masterofpis OWFS[21511]: sqlbackup DEBUG: starting from 2017-07-20 17:05:50
Jul 21 17:20:50 masterofpis OWFS[21511]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Jul 21 17:20:50 masterofpis OWFS[21511]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20170721
Jul 21 17:20:50 masterofpis OWFS[21511]: sqlbackup DEBUG: processing mysql database, weatherpi
Jul 21 17:20:50 masterofpis OWFS[21511]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170721/weatherpi-host.masterofpis-201707211720-daily.gz
Jul 21 17:20:51 masterofpis OWFS[21511]: sqlbackup DEBUG: 0.18 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1500534350"  --single-transaction --skip-opt
Jul 21 17:20:51 masterofpis OWFS[21511]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.05 secs
Jul 21 17:20:51 masterofpis OWFS[21511]: sqlbackup DEBUG: processing mysql database, mesoraw
Jul 21 17:20:51 masterofpis OWFS[21511]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20170721/mesoraw-host.masterofpis-201707211720-daily.gz
Jul 21 17:20:51 masterofpis OWFS[21511]: sqlbackup DEBUG: 0.39 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1500534350"  --single-transaction --skip-opt
Jul 21 17:20:51 masterofpis OWFS[21511]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.06 secs
Back to top

MySQL files:

     
/opt/backups/mysql-backups/20170721

-rw-r--r-- 1 root 129840 Jul 21 16:00 weatherpi-host.masterofpis-201707211600-daily.gz
-rw-r--r-- 1 root 221294 Jul 21 16:01 mesoraw-host.masterofpis-201707211600-daily.gz
-rw-r--r-- 1 root 129491 Jul 21 16:20 weatherpi-host.masterofpis-201707211620-daily.gz
-rw-r--r-- 1 root 220349 Jul 21 16:20 mesoraw-host.masterofpis-201707211620-daily.gz
-rw-r--r-- 1 root 129372 Jul 21 16:40 weatherpi-host.masterofpis-201707211640-daily.gz
-rw-r--r-- 1 root 219502 Jul 21 16:40 mesoraw-host.masterofpis-201707211640-daily.gz
-rw-r--r-- 1 root 128959 Jul 21 17:01 weatherpi-host.masterofpis-201707211701-daily.gz
-rw-r--r-- 1 root 218484 Jul 21 17:01 mesoraw-host.masterofpis-201707211701-daily.gz
-rw-r--r-- 1 root 128533 Jul 21 17:20 weatherpi-host.masterofpis-201707211720-daily.gz
-rw-r--r-- 1 root 217155 Jul 21 17:20 mesoraw-host.masterofpis-201707211720-daily.gz
Back to top

sqlite files:

     
/opt/backups/sql-backups/20170721

-rw-r--r-- 1 root 10382 Jul 21 08:20 pmon.sdb-host.masterofpis-201707210820-daily.gz
-rw-r--r-- 1 root 60898 Jul 21 08:20 cmon.sdb-host.masterofpis-201707210820-daily.gz
-rw-r--r-- 1 root 10351 Jul 21 08:40 pmon.sdb-host.masterofpis-201707210840-daily.gz
-rw-r--r-- 1 root 60945 Jul 21 08:40 cmon.sdb-host.masterofpis-201707210840-daily.gz
-rw-r--r-- 1 root 10332 Jul 21 09:01 pmon.sdb-host.masterofpis-201707210901-daily.gz
-rw-r--r-- 1 root 60952 Jul 21 09:01 cmon.sdb-host.masterofpis-201707210901-daily.gz
-rw-r--r-- 1 root 10314 Jul 21 09:20 pmon.sdb-host.masterofpis-201707210920-daily.gz
-rw-r--r-- 1 root 60880 Jul 21 09:20 cmon.sdb-host.masterofpis-201707210920-daily.gz
-rw-r--r-- 1 root 10299 Jul 21 09:40 pmon.sdb-host.masterofpis-201707210940-daily.gz
-rw-r--r-- 1 root 60820 Jul 21 09:40 cmon.sdb-host.masterofpis-201707210940-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