Messmate Farm, Broomfield, Victoria

24-Nov-2017 12:40

❰ Current Conditions       SqlBackup README❯

This page shows a summary of the output from the sqlbackup that last ran on Friday November 24, 2017 at 12:41
It started the capture from 2017-11-23 12:25:53

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>1511400353"  --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>1511400353

INSERT INTO `archive` VALUES (1511400360,17,1,1013.99,963.640209326429,1016.3997334145,31.8240424184072,27.851575,32.0625,30.9224,30.6608,1.49904191417958,8.21217459991958,2.54565077365719,356.565656565657,0,0,12.6163013872571,32.0625,32.0625,0.0215776325823448,1811.81,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400420,17,1,1013.99,963.615263556536,1016.37368081414,31.5808100137748,27.7604,32.0833333333333,30.7044666666667,27.8989,1.26454684772727,347.558756961654,1.95580486268784,328.282828282828,0,0,11.2014327143537,32.0833333333333,32.0833333333333,0.0215675925795626,1778.87,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400480,17,1,1013.99,963.640365177307,1016.39989618038,31.9145466700646,27.781225,32.296875,30.593475,30.2837,1.71030805348245,14.2861160117777,2.23520555735753,23.6363636363636,0,0,12.6290369700766,32.296875,32.296875,0.0215645830383906,1811.81,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400540,17,1,1014.04425,963.659395304343,1016.41977066022,31.7398730403222,27.820325,32.265625,30.6762,26.826475,1.11923670086981,29.1364042247788,2.11756315960187,14.7474747474747,0,0,10.7656986114752,32.265625,32.265625,0.0215639364203531,1795.34,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400600,17,1,1013.99,963.736619551026,1016.50042125707,33.0792420944796,27.882825,32.421875,30.758975,30.6855333333333,0.36550839413807,4.60673734032973,1.06172263974483,5.85858585858586,0,0,12.9380409332326,32.421875,32.421875,0.0215518986514397,1778.87,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400660,17,1,1013.91733333333,963.63340212126,1016.39262417783,33.4380036174041,27.8437666666667,32.6041666666667,30.5955666666667,30.41925,0.124178086519863,330.707070707071,0.248356173039725,330.707070707071,0,0,12.9615051859092,32.6041666666667,32.6041666666667,0.021542303895323,1778.87,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400720,17,1,1013.9355,963.682293768223,1016.4436851079,33.4686847018321,27.859375,32.828125,30.59555,29.7635,0.335771010260945,333.631916151297,0.558801389339382,311.983805668016,0,0,12.8204617984314,32.828125,32.828125,0.0215354592324652,1778.87,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400780,17,1,1013.881,963.680642364045,1016.44196043259,32.9198587364641,27.8672,33,30.59345,30.023275,1.49415456456694,32.7695989586035,2.11102747083767,55.1515151515151,0,0,13.1009326407194,33,33,0.0215321481428481,1795.34,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400840,17,1,1013.91733333333,963.770964088979,1016.53628960522,32.9480792283937,27.8333666666667,33.125,30.5997,30.9425,1.90095954114156,324.045994216751,2.17932541842359,245.858585858586,0,0,13.6715759956145,33.125,33.125,0.0215568805687175,1800.83,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400900,17,1,1013.8265,963.555490565915,1016.31125570534,31.7829819221457,27.85935,32.75,30.5971,27.442775,2.06113448964665,347.429001289848,2.51460625202722,294.343434343434,0,0,11.5191225141175,32.75,32.75,0.0215749956223301,1778.87,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511400960,17,1,1013.881,963.621413479962,1016.3801036069,31.8551124764117,27.867175,32.5625,30.598125,29.24105,2.03785109842417,10.7549975865354,2.79400694669691,331.515151515152,0,0,12.3226929693598,32.5625,32.5625,0.0216062479110858,1778.87,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511401020,17,1,1013.91733333333,963.670544858669,1016.43141491061,32.8899980248156,27.8750333333333,32.625,30.5983,30.6972,1.00934495966145,345.211728025658,1.55222608149828,343.636363636364,0,0,13.1187358292376,32.625,32.625,0.0216183769418969,1778.87,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511401080,17,1,1013.9355,963.600538927008,1016.35830285808,32.4347364308894,27.929675,32.5,30.599175,28.809275,0.997689229077544,341.536809403771,1.39700347334846,341.212121212121,0,0,12.042973263904,32.5,32.5,0.0216116983344818,1762.3975,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,20228331,NULL,1010,1162);

[...]

INSERT INTO `archive` VALUES (1511486940,17,1,1016.43525,965.721896819667,1018.57376474776,29.1100483076208,26.89845,27.875,34.1431,43.27945,0.153005142319117,31.3072755580561,0.248356173039725,31.7171717171717,0,0,14.2254445779063,27.875,27.875,0.0141623898325666,1416.505,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487000,17,1,1016.45333333333,965.727056673846,1018.57915344563,28.9918681457742,26.8229333333333,27.8541666666667,34.0323,41.6736,0,NULL,0,NULL,0,0,13.6235760087011,27.8541666666667,27.8541666666667,0.0142318627110798,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487060,17,1,1016.4895,965.761729718427,1018.61536426158,29.0504322903991,26.92185,27.90625,34.061025,41.599875,0,NULL,0,NULL,0,0,13.6429743769868,27.90625,27.90625,0.0142957987772312,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487120,17,1,1016.43525,965.723865750951,1018.57582100276,29.4704672548256,26.9844,28.09375,34.14195,43.00885,0,NULL,0,NULL,0,0,14.3251957332955,28.09375,28.09375,0.0143632030225801,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487180,17,1,1016.52566666667,965.801848165543,1018.65726197375,28.7854796265304,26.8958666666667,28.1458333333333,33.8165,41.8052666666667,0.86063383980381,31.2354774529785,1.59657539811252,30.9090909090909,0,0,13.9334525947967,28.1458333333333,28.1458333333333,0.0144472570493477,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487240,17,1,1016.4895,965.758967162276,1018.61247918471,28.7738069501237,26.914075,27.9375,33.815925,41.1441,0.372534259559588,31.2121196423839,0.93133564889897,30.9090909090909,0,0,13.5014991429453,27.9375,27.9375,0.0145153734811708,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487300,17,1,1016.43525,965.722061763649,1018.57393700714,28.8853554228035,26.953125,28.03125,33.89915,42.913825,0.701827935420295,32.321404441372,1.24178086519863,25.2525252525253,0,0,14.2347987684231,28.03125,28.03125,0.0145754644531547,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487360,17,1,1016.4895,965.811205336851,1018.66703413634,29.1921344506056,26.890625,28.140625,33.820525,43.0713,0.496712346079451,25.1262650544203,0.993424692158901,25.2525252525253,0,0,14.3897997327722,28.140625,28.140625,0.0146394774459302,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487420,17,1,1016.43525,965.719788938925,1018.57156338074,29.104917993258,26.9844,28.21875,33.90205,42.143,0.600991594486873,19.3594270422454,1.29406637531225,18.7878787878788,0,0,14.1230169077449,28.21875,28.21875,0.0147039353130048,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487480,17,1,1016.381,965.667568661715,1018.51702707781,29.4794291879756,26.9479333333333,28.2708333333333,33.8226333333333,41.926,0.124178086519863,18.2491562647031,0.248356173039725,17.979797979798,0,0,14.0899713471501,28.2708333333333,28.2708333333333,0.0147741322806969,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487540,17,1,1016.43525,965.734896682705,1018.58734116476,29.3673561205636,26.90625,28.3125,33.98645,43.93595,0.725665693100448,22.9152409545322,1.5367038206833,22.8282828282828,0,0,14.8527962090812,28.3125,28.3125,0.0148514580696675,1449.45,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,20228331,NULL,1010,1162);
INSERT INTO `archive` VALUES (1511487600,17,1,1016.43525,965.724663711535,1018.57665435354,29.721618546507,26.9922,28.34375,33.82225,42.4839,0.0155222608149828,24.4444444444444,0.0620890432599313,24.4444444444444,0,0,14.359743134167,28.34375,28.34375,0.0149342054135002,1449.45,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,20228331,NULL,1010,1162);
/*!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-11-24 12:40:53
    Back to top

Extract from the mesoraw Database dump file:

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

INSERT INTO `archive` VALUES (1511400377,17,1013.99,NULL,NULL,27.8125,32.0625,30.5955,NULL,1.95580486268784,328.282828282828,NULL,NULL,0,0,NULL,32.0625,NULL,NULL,NULL,1778.87,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 (1511400387,17,1013.99,963.606591803351,1016.36462429861,27.6875,32.125,30.6018,26.9035,1.34112333441452,7.47474747474747,NULL,NULL,0,0,10.689659322774,32.125,32.125,NULL,NULL,1778.87,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 (1511400405,17,1013.99,963.623935309721,1016.38273732901,27.7812,32.0625,30.9161,28.8943,0.496712346079451,9.8989898989899,NULL,NULL,0,0,11.7138159260123,32.0625,32.0625,NULL,NULL,1778.87,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 (1511400423,17,1013.99,963.645163051976,1016.40490693354,27.7812,32.25,30.5914,30.887,1.1796918219387,6.66666666666667,NULL,NULL,0,0,12.8901241850426,32.25,32.25,NULL,NULL,1778.87,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 (1511400442,17,1013.99,963.614007631444,1016.37236916418,27.8125,32.25,30.5955,27.5159,1.47052997194574,13.1313131313131,NULL,NULL,0,0,11.1346135583588,32.25,32.25,NULL,NULL,1844.75,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 (1511400450,17,1013.99,963.636452883441,1016.3958103005,27.75,32.3125,30.5935,29.8386,1.95580486268784,9.09090909090909,NULL,NULL,0,0,12.4166208174025,32.3125,32.3125,NULL,NULL,1844.75,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 (1511400468,17,1013.99,963.665837142369,1016.42649831715,27.7812,32.375,30.5935,32.8933,2.23520555735753,23.6363636363636,NULL,NULL,0,0,13.9650752389761,32.375,32.375,NULL,NULL,1778.87,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 (1511400486,17,1013.99,963.619762249553,1016.37837911217,27.8438,32.1875,30.5955,28.2378,2.04893842757773,46.2626262626263,NULL,NULL,0,0,11.4725775962023,32.1875,32.1875,NULL,NULL,1778.87,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 (1511400505,17,1013.99,963.602298332048,1016.36014032739,27.7812,32.25,30.9203,26.25,2.11756315960187,14.7474747474747,NULL,NULL,0,0,10.426236144444,32.25,32.25,NULL,NULL,1844.75,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 (1511400514,17,1013.99,963.599075678146,1016.35677468528,27.8125,32.25,30.5976,25.9017,0.124178086519863,14.7474747474747,NULL,NULL,0,0,10.2260680666013,32.25,32.25,NULL,NULL,1778.87,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 (1511400532,17,1014.207,963.816444957624,1016.58378836843,27.8438,32.375,30.5914,26.9164,0.186267129779794,14.7474747474747,NULL,NULL,0,0,10.9087179643101,32.375,32.375,NULL,NULL,1778.87,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 (1511400552,17,1013.99,963.738548639624,1016.50243593641,27.8125,32.4375,30.5914,30.9062,1.06172263974483,5.85858585858586,NULL,NULL,0,0,13.0612054054201,32.4375,32.4375,NULL,NULL,1778.87,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 (1511400571,17,1013.99,963.705800004496,1016.46823428941,27.875,32.3125,30.9245,27.581,0.0588211988778297,6.66666666666667,NULL,NULL,0,0,11.2233816705906,32.3125,32.3125,NULL,NULL,1778.87,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 (1511400579,17,1013.99,NULL,NULL,27.9688,32.375,30.5955,NULL,0.279400694669691,6.66666666666667,NULL,NULL,0,0,NULL,32.375,NULL,NULL,NULL,1778.87,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 (1511400597,17,1013.99,963.765510008957,1016.53059353742,27.875,32.5625,30.9245,33.5694,0.0620890432599313,329.89898989899,NULL,NULL,0,0,14.4425835415062,32.5625,32.5625,NULL,NULL,1778.87,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 (1511400615,17,1013.99,963.743814276273,1016.50793520121,27.875,32.5625,30.5997,31.2514,0.248356173039725,330.707070707071,NULL,NULL,0,0,13.3393163858955,32.5625,32.5625,NULL,NULL,1778.87,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 (1511400624,17,1013.99,NULL,NULL,27.8125,32.5625,30.5935,NULL,0.124178086519863,330.707070707071,NULL,NULL,0,0,NULL,32.5625,NULL,NULL,NULL,1778.87,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 (1511400642,17,1013.772,963.522989966246,1016.27731304582,27.8438,32.6875,30.5935,29.5871,0,NULL,NULL,NULL,0,0,12.6091037183399,32.6875,32.6875,NULL,NULL,1778.87,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 (1511400661,17,1013.772,963.517735926735,1016.27182588236,27.8438,32.75,30.5976,28.9282,0.0588211988778297,329.89898989899,NULL,NULL,0,0,12.319249686479,32.75,32.75,NULL,NULL,1778.87,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 (1511400679,17,1013.99,963.732251442857,1016.49585934243,27.8125,32.8125,30.5935,29.5972,0.372534259559588,311.313131313131,NULL,NULL,0,0,12.7214386906933,32.8125,32.8125,NULL,NULL,1778.87,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 (1511487463,17,1016.381,965.690790543914,1018.54127887857,26.9688,28.25,33.8257,45.1,0,NULL,NULL,NULL,0,0,15.2032304836522,28.25,28.2890260192068,NULL,NULL,1449.45,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 (1511487481,17,1016.381,965.688436022202,1018.53881993119,26.9375,28.25,33.8211,44.783,0.0620890432599313,18.7878787878788,NULL,NULL,0,0,15.0933774514074,28.25,28.2621769756523,NULL,NULL,1449.45,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 (1511487499,17,1016.381,965.69756173106,1018.54835037515,26.875,28.375,34.1495,45.6786,0.248356173039725,17.979797979798,NULL,NULL,0,0,15.5152160469099,28.375,28.470073365077,NULL,NULL,1449.45,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 (1511487507,17,1016.598,965.889623954283,1018.74893059496,26.875,28.375,34.1495,43.7921,1.5367038206833,22.8282828282828,NULL,NULL,0,0,14.858163605249,28.375,28.375,NULL,NULL,1449.45,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 (1511487525,17,1016.381,965.663965023275,1018.51326361322,26.9375,28.25,33.8257,41.4901,1.05551373541883,24.4444444444444,NULL,NULL,0,0,13.9100191336929,28.25,28.25,NULL,NULL,1449.45,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 (1511487543,17,1016.598,965.861675432195,1018.71974257091,27,28.1875,33.8234,40.4995,0.0620890432599313,24.4444444444444,NULL,NULL,0,0,13.4821226794299,28.1875,28.1875,NULL,NULL,1449.45,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 (1511487561,17,1016.381,965.67858550987,1018.5285325371,27.0312,28.375,33.8234,43.1424,0,NULL,NULL,NULL,0,0,14.62612465243,28.375,28.375,NULL,NULL,1449.45,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 (1511487570,17,1016.381,965.68353781613,1018.53370448405,26.9688,28.375,33.8211,43.8041,0,NULL,NULL,NULL,0,0,14.8624209086477,28.375,28.375,NULL,NULL,1449.45,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 (1511487588,17,1016.381,965.674856087944,1018.52463771072,26.9688,28.4375,33.8211,42.4896,0,NULL,NULL,NULL,0,0,14.4459728494619,28.4375,28.4375,NULL,NULL,1449.45,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 (1511487606,17,1016.598,965.876057856749,1018.73476284914,26.9688,28.4375,33.8211,41.828,0.124178086519863,24.4444444444444,NULL,NULL,0,0,14.2031551763061,28.4375,28.4375,NULL,NULL,1449.45,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 (1511487624,17,1016.381,965.652860738419,1018.50166683785,26.9062,28.3125,33.8234,39.8518,0.0620890432599313,24.4444444444444,NULL,NULL,0,0,13.3459140757468,28.3125,28.3125,NULL,NULL,1449.45,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 (1511487635,17,1016.381,965.646841576335,1018.49538071708,27.0625,28.25,33.8211,39.1878,0,NULL,NULL,NULL,0,0,13.0326697161056,28.25,28.25,NULL,NULL,1449.45,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-11-24 12:41:01

Back to top

Disk Usage:

    
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           379M  680K  379M   1% /run
/dev/sda1       3.7G  3.0G  552M  85% /
/dev/sdb1       917G   19G  853G   3% /opt
tmpfs           1.5G  288M  1.2G  19% /tmp
cgroup           12K     0   12K   0% /sys/fs/cgroup

Back to top

Memory Usage:

    
              total        used        free      shared  buff/cache   available
Mem:           3.7G        2.1G        241M        295M        1.4G        964M
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)
cgroup on /sys/fs/cgroup type tmpfs (rw,relatime,size=12k,mode=755)

DEBUG output

Back to top

Log snippet:

    
Nov 24 11:40:58 masterofpis OWFS[1023]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Nov 24 11:40:58 masterofpis OWFS[1023]: cheetahgenerator: Generated 1 files for report sqlbackup in 9.53 seconds
Nov 24 11:40:58 masterofpis OWFS[1023]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup: version is 0.3
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup DEBUG: starting from 2017-11-23 11:46:29
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20171124
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup DEBUG: processing mysql database, weatherpi
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20171124/weatherpi-host.masterofpis-201711241201-daily.gz
Nov 24 12:01:29 masterofpis OWFS[1023]: sqlbackup DEBUG: 0.38 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1511397989"  --single-transaction --skip-opt
Nov 24 12:01:37 masterofpis OWFS[1023]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 8.04 secs
Nov 24 12:01:37 masterofpis OWFS[1023]: sqlbackup DEBUG: processing mysql database, mesoraw
Nov 24 12:01:37 masterofpis OWFS[1023]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20171124/mesoraw-host.masterofpis-201711241201-daily.gz
Nov 24 12:01:38 masterofpis OWFS[1023]: sqlbackup DEBUG: 0.72 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1511397989"  --single-transaction --skip-opt
Nov 24 12:01:39 masterofpis OWFS[1023]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.64 secs
Nov 24 12:01:40 masterofpis OWFS[1023]: sqlbackup: Total time used in backups and report output: 10.81 seconds
Nov 24 12:01:40 masterofpis OWFS[1023]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Nov 24 12:01:40 masterofpis OWFS[1023]: cheetahgenerator: Generated 1 files for report sqlbackup in 11.10 seconds
Nov 24 12:01:40 masterofpis OWFS[1023]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup: version is 0.3
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup DEBUG: starting from 2017-11-23 12:05:50
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20171124
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup DEBUG: processing mysql database, weatherpi
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20171124/weatherpi-host.masterofpis-201711241220-daily.gz
Nov 24 12:20:50 masterofpis OWFS[1023]: sqlbackup DEBUG: 0.38 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1511399150"  --single-transaction --skip-opt
Nov 24 12:20:51 masterofpis OWFS[1023]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.63 secs
Nov 24 12:20:51 masterofpis OWFS[1023]: sqlbackup DEBUG: processing mysql database, mesoraw
Nov 24 12:20:51 masterofpis OWFS[1023]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20171124/mesoraw-host.masterofpis-201711241220-daily.gz
Nov 24 12:20:51 masterofpis OWFS[1023]: sqlbackup DEBUG: 0.62 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1511399150"  --single-transaction --skip-opt
Nov 24 12:20:52 masterofpis OWFS[1023]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.63 secs
Nov 24 12:20:59 masterofpis OWFS[1023]: sqlbackup: Total time used in backups and report output: 8.85 seconds
Nov 24 12:20:59 masterofpis OWFS[1023]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
Nov 24 12:20:59 masterofpis OWFS[1023]: cheetahgenerator: Generated 1 files for report sqlbackup in 9.14 seconds
Nov 24 12:20:59 masterofpis OWFS[1023]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup: version is 0.3
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup DEBUG: starting from 2017-11-23 12:25:53
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup DEBUG: databases, mysql 2 named ['weatherpi', 'mesoraw']
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20171124
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup DEBUG: processing mysql database, weatherpi
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20171124/weatherpi-host.masterofpis-201711241240-daily.gz
Nov 24 12:40:53 masterofpis OWFS[1023]: sqlbackup DEBUG: 0.38 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1511400353"  --single-transaction --skip-opt
Nov 24 12:40:54 masterofpis OWFS[1023]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.62 secs
Nov 24 12:40:54 masterofpis OWFS[1023]: sqlbackup DEBUG: processing mysql database, mesoraw
Nov 24 12:40:54 masterofpis OWFS[1023]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20171124/mesoraw-host.masterofpis-201711241240-daily.gz
Nov 24 12:41:02 masterofpis OWFS[1023]: sqlbackup DEBUG: 8.17 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  mesoraw archive -w"dateTime>1511400353"  --single-transaction --skip-opt
Nov 24 12:41:02 masterofpis OWFS[1023]: sqlbackup DEBUG: Created /tmp/sqlbackup/mesoraw.inc in 0.63 secs

Back to top

MySQL files:

    
/opt/backups/mysql-backups/20171124

-rw-r--r-- 1 root 132920 Nov 24 11:20 weatherpi-host.masterofpis-201711241120-daily.gz
-rw-r--r-- 1 root 252527 Nov 24 11:20 mesoraw-host.masterofpis-201711241120-daily.gz
-rw-r--r-- 1 root 132839 Nov 24 11:40 weatherpi-host.masterofpis-201711241140-daily.gz
-rw-r--r-- 1 root 252333 Nov 24 11:40 mesoraw-host.masterofpis-201711241140-daily.gz
-rw-r--r-- 1 root 132522 Nov 24 12:01 weatherpi-host.masterofpis-201711241201-daily.gz
-rw-r--r-- 1 root 252077 Nov 24 12:01 mesoraw-host.masterofpis-201711241201-daily.gz
-rw-r--r-- 1 root 132568 Nov 24 12:20 weatherpi-host.masterofpis-201711241220-daily.gz
-rw-r--r-- 1 root 252027 Nov 24 12:20 mesoraw-host.masterofpis-201711241220-daily.gz
-rw-r--r-- 1 root 132454 Nov 24 12:40 weatherpi-host.masterofpis-201711241240-daily.gz
-rw-r--r-- 1 root 251682 Nov 24 12:41 mesoraw-host.masterofpis-201711241240-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