Messmate Farm, Broomfield, Victoria

02-May-2018 09:53

❰ Current Conditions       SqlBackup README❯

This page shows a summary of the output from the sqlbackup that last ran on Wednesday May 02, 2018 at 09:53
It started the capture from 2018-05-01 09:38:43

Databases :: mysql.weatherpi  
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>1525131523"  --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>1525131523

INSERT INTO `archive` VALUES (1525131540,17,1,1026.30833333333,973.503733114465,1026.70046371012,19.0475681322339,18.4270666666667,20.7291666666667,37.0699666666667,31.9032666666667,0.357011998744605,346.060606060606,0.807157562379107,346.060606060606,0,0,3.38952834446654,20.7291666666667,20.7291666666667,0.00817424925655433,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525131600,17,1,1026.381,973.578901673164,1026.77896085828,19.1454526653653,18.38285,20.953125,37.070775,32.676425,0.678077709286092,14.0004706669535,0.941139182045275,20.4040404040404,0,0,3.92450289826921,20.953125,20.953125,0.00822461379780186,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525131660,17,1,1026.381,973.572793665736,1026.77258237992,19.1419975452345,18.414075,21.046875,37.07385,31.312675,0.678988037363964,342.277351623604,0.782321945075135,334.747474747475,0,0,3.40112518880624,21.046875,21.046875,0.00827665226206037,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525131720,17,1,1026.381,973.577947029443,1026.77796394165,19.5015791112303,18.429675,21.265625,37.07815,31.875775,0.594267112192191,15.1507045778299,0.788896079067363,39.7979797979798,0,0,3.84409490525629,21.265625,21.265625,0.00833613172863993,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525131780,17,1,1026.381,973.646277680417,1026.84932034552,19.7111292299515,18.4374666666667,21.4166666666667,37.0757,32.1476333333333,0.578462919705027,29.1198214010504,0.977902431343919,27.6767676767677,0,0,4.09638472354316,21.4166666666667,21.4166666666667,0.00842255022819923,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525131840,17,1,1026.381,973.67633737934,1026.88071110642,19.6970384617738,18.5078,21.53125,36.9951,31.434175,0.703197546668676,357.341434979908,0.851506878993344,358.181818181818,0,0,3.87667673790366,21.53125,21.53125,0.00847819282553048,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525131900,17,1,1026.381,973.649602020624,1026.85279188995,19.8833882257334,18.4766,21.453125,37.079375,31.1628,0.274667125969147,358.989898989899,0.394448039533681,358.989898989899,0,0,3.68569680852906,21.453125,21.453125,0.00853889478571496,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525131960,17,1,1026.381,973.680397115621,1026.88495060971,20.020502627509,18.476575,21.640625,37.0763,31.9819,0.489407752754753,10.1932104016388,0.591672059300522,5.05050505050505,0,0,4.21768170472342,21.640625,21.640625,0.00858451046560726,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525132020,17,1,1026.381,973.684525224825,1026.88926151337,20.1867207299383,18.5729333333333,21.875,36.9723333333333,32.2858666666667,0.680256272207493,31.5085215926478,0.869246605639039,26.8686868686869,0,0,4.5567725207948,21.875,21.875,0.00864372247386431,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525132080,17,1,1026.381,973.680504701875,1026.88506295994,20.3436885537329,18.52345,21.96875,37.08435,31.367025,0.498754748818264,26.8686868686869,0.807157562379107,26.8686868686869,0,0,4.22607814987744,21.96875,21.96875,0.0087096769875677,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525132140,17,1,1026.381,973.67571179603,1026.88005782198,20.0879963666062,18.5625,21.8125,37.0823,30.7831,0.53219179937084,9.27685233991588,0.93133564889897,357.373737373737,0,0,3.82312394134789,21.8125,21.8125,0.00875909206309854,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525132200,17,1,1026.381,973.683696493521,1026.8883960855,20.3902269132708,18.5625,21.859375,36.924325,32.163325,0.348319850984746,22.8282828282828,0.638630159245008,22.8282828282828,0,0,4.48881517265912,21.859375,21.859375,0.00879622070210732,1185.91,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525132260,17,1,1026.381,973.68716083426,1026.89201382864,20.5161539812528,18.5625,21.96875,36.92615,32.585775,0.403578781189554,23.0458406131541,0.558801389339382,22.8282828282828,0,0,4.77077920591713,21.96875,21.96875,0.00883576263505039,1185.91,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,20228958,NULL,1313,1465);

[...]

INSERT INTO `archive` VALUES (1525218060,17,1,1019.0985,966.818796185133,1019.71930716613,16.1227846141919,19.062525,17.75,39.0673,51.952475,1.57469251162523,11.7899599525401,2.14207199246763,12.3232323232323,0,0,7.74815968219007,17.75,17.75,0.00336785271429481,527.072,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218120,17,1,1019.13466666667,966.856243718163,1019.7584151573,16.0900006488067,19.1041666666667,17.8125,38.8503,52.4995,1.78284252789231,22.8731671702203,1.86267129779794,19.5959595959596,0,0,7.95974661732849,17.8125,17.8125,0.00340932883533103,570.994,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218180,17,1,1019.0985,966.819540361709,1019.72008434031,16.4451374584595,19.14065,17.90625,38.9091,51.62165,1.3544859763335,28.8762057962208,1.50633417995833,29.2929292929293,0,0,7.79858468658489,17.90625,17.90625,0.00345803644720221,592.955,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218240,17,1,1018.99,966.715773596419,1019.61171639665,16.4301583296035,19.1172,17.9375,38.90455,51.322975,1.40143840500988,17.5130729311952,1.86267129779794,11.5151515151515,0,0,7.74222867868962,17.9375,17.9375,0.00351014903474092,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,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218300,17,1,1019.0985,966.820502930146,1019.72108959007,16.2524994716395,19.171875,18.015625,38.9814,51.4947,1.80793490439774,10.4744604627634,1.92476034105787,9.8989898989899,0,0,7.86330409863905,18.015625,18.015625,0.00357032955065212,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.96,4.93,NULL,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218360,17,1,1019.06233333333,966.782601936207,1019.68150801902,16.1220252064593,19.125,18,38.8512,50.6994333333333,1.88990333431545,7.05274763670221,2.11102747083767,358.989898989899,0,0,7.62050573679031,18,18,0.00363529716506643,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.96,4.93,NULL,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218420,17,1,1019.04425,966.768906475316,1019.66720528126,16.2868986433695,19.1172,18.046875,38.90455,51.364475,1.80058225453801,27.6767676767677,2.23520555735753,27.6767676767677,0,0,7.85492356329167,18.046875,18.046875,0.00369980158311794,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.96,4.93,NULL,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218540,17,1,1018.99,966.718778972218,1019.61485503679,16.4272152847054,19.1354,18.1875,38.7435333333333,51.2249666666667,1.83162677616797,0.202020202020194,2.04893842757773,0.2020202020202,0,0,7.94457629924062,18.1875,18.1875,0.00380216909219742,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.96,4.93,NULL,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218600,17,1,1019.04425,966.722617486637,1019.61886375845,16.7583396551617,19.16405,18.3125,38.909725,51.447875,1.59879286394323,14.7474747474747,2.04893842757773,14.7474747474747,0,0,8.12366907142168,18.3125,18.3125,0.00386756191137823,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.96,4.93,NULL,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218660,17,1,1019.04425,966.772221023197,1019.67066680122,16.937254239171,19.1562,18.484375,38.825775,50.73195,1.57218327397469,19.3112620719025,1.9868493843178,23.6363636363636,0,0,8.07575479723789,18.484375,18.484375,0.00393501179110982,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.96,4.93,NULL,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218720,17,1,1018.99,966.784988112016,1019.6840000012,17.3176099399988,19.1979,18.6041666666667,38.9614,50.2974,1.19430100858809,9.82674463331985,1.90649885774613,358.181818181818,0,0,8.05937487940547,18.6041666666667,18.6041666666667,0.00400739770605437,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.95666666666667,4.93,NULL,20228958,NULL,1313,1465);
INSERT INTO `archive` VALUES (1525218780,17,1,1019.15275,966.975487635691,1019.88294637715,17.5060980050704,19.164075,18.78125,38.82965,50.609175,1.26617298933646,34.9494949494949,1.67640416801815,34.9494949494949,0,0,8.31325493372308,18.78125,18.78125,0.00407283322917636,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.96,4.93,NULL,20228958,NULL,1313,1465);
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2018-05-02  9:53:44

Back to top

Disk Usage:

    
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           379M  688K  378M   1% /run
/dev/sda1       3.7G  2.4G  1.2G  67% /
/dev/sdb1       3.7G  2.7G  739M  79% /usr
/dev/sdb2       3.7G  1.2G  2.3G  34% /home
tmpfs           1.5G  212M  1.3G  14% /tmp
cgroup           12K     0   12K   0% /sys/fs/cgroup
/dev/sdc1       917G   44G  827G   6% /opt

Back to top

Memory Usage:

    
              total        used        free      shared  buff/cache   available
Mem:           3.7G        409M        808M        220M        2.5G        2.7G
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=1929344k,nr_inodes=209519,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=387740k,mode=755)
/dev/sda1 on / type ext4 (rw,noatime,errors=remount-ro,data=ordered)
/dev/sdb1 on /usr type ext4 (rw,noatime,errors=remount-ro,data=ordered)
pstore on /sys/fs/pstore type pstore (rw,relatime)
/dev/sdb2 on /home type ext4 (rw,noatime,errors=remount-ro,data=ordered)
tmpfs on /tmp type tmpfs (rw,nosuid,nodev,relatime,size=1550960k)
rpc_pipefs on /run/rpc_pipefs type rpc_pipefs (rw,relatime)
tmpfs on /var/log type tmpfs (rw,nosuid,nodev,relatime,size=1550960k)
tmpfs on /var/lib/weewx type tmpfs (rw,nosuid,nodev,relatime,size=1550960k)
cgroup on /sys/fs/cgroup type tmpfs (rw,relatime,size=12k,mode=755)
/dev/sdc1 on /opt type ext4 (rw,relatime,data=ordered)
fusectl on /sys/fs/fuse/connections type fusectl (rw,relatime)

DEBUG output

Back to top

Log snippet:

    
May  2 08:53:43 masterofpis weewx[1881]: sqlbackup DEBUG: processing mysql database, weatherpi
May  2 08:53:43 masterofpis weewx[1881]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20180502/weatherpi-host.masterofpis-201805020853-daily.gz
May  2 08:53:43 masterofpis weewx[1881]: sqlbackup DEBUG: 0.15 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1525127923"  --single-transaction --skip-opt
May  2 08:53:43 masterofpis weewx[1881]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.04 secs
May  2 08:53:43 masterofpis weewx[1881]: sqlbackup: Total time used in backups and report output: 0.32 seconds
May  2 08:53:43 masterofpis weewx[1881]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
May  2 08:53:43 masterofpis weewx[1881]: cheetahgenerator: mem-cg: def teardown 00  77552 (kb) for sqlbackup - /home/weewx/skins/sqlbackup/index.html.tmpl
May  2 08:53:44 masterofpis weewx[1881]: cheetahgenerator: Generated 1 files for report sqlbackup in 0.55 seconds
May  2 08:53:44 masterofpis weewx[1881]: cheetahgenerator: mem-cg: Memory usage: end {skip to 00} 77552 (kb) for sqlbackup
May  2 08:53:44 masterofpis weewx[1881]: cheetahgenerator: cg: Garbage collector1: collected 103 objects for report sqlbackup
May  2 08:53:44 masterofpis weewx[1881]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
May  2 09:23:52 masterofpis weewx[25887]: cheetahgenerator: mem-cg: Memory usage: start 60864 (kb) for sqlbackup
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup: version is 0.3
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 0
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: starting from 2018-05-01 09:08:52
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: databases, mysql 1 named ['weatherpi']
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20180502
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: processing mysql database, weatherpi
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20180502/weatherpi-host.masterofpis-201805020923-daily.gz
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: 0.17 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1525129732"  --single-transaction --skip-opt
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.04 secs
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup: Total time used in backups and report output: 0.31 seconds
May  2 09:23:52 masterofpis weewx[25887]: sqlbackup DEBUG: Resetting weewx.debug logging back to 0 mode
May  2 09:23:52 masterofpis weewx[25887]: cheetahgenerator: mem-cg: def teardown 00  60864 (kb) for sqlbackup - /home/weewx/skins/sqlbackup/index.html.tmpl
May  2 09:23:52 masterofpis weewx[25887]: cheetahgenerator: Generated 1 files for report sqlbackup in 0.54 seconds
May  2 09:23:52 masterofpis weewx[25887]: cheetahgenerator: mem-cg: Memory usage: end {skip to 00} 60864 (kb) for sqlbackup
May  2 09:23:52 masterofpis weewx[25887]: cheetahgenerator: cg: Garbage collector1: collected 103 objects for report sqlbackup
May  2 09:23:52 masterofpis weewx[25887]: copygenerator: copied 0 files to /var/www/html/weewx/sqlbackup
May  2 09:52:42 masterofpis weewx[11950]: reportengine: Running report sqlbackupweek
May  2 09:52:42 masterofpis weewx[11950]: reportengine: Found configuration file /home/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
May  2 09:52:42 masterofpis weewx[11950]: reportengine: Report sqlbackupweek skipped due to report_timing setting
May  2 09:52:42 masterofpis weewx[11950]: reportengine: Running report sqlbackup
May  2 09:52:42 masterofpis weewx[11950]: reportengine: Found configuration file /home/weewx/skins/sqlbackup/skin.conf for report sqlbackup
May  2 09:52:42 masterofpis weewx[11950]: reportengine: Report sqlbackup skipped due to report_timing setting
May  2 09:53:43 masterofpis weewx[11950]: reportengine: Running report sqlbackupweek
May  2 09:53:43 masterofpis weewx[11950]: reportengine: Found configuration file /home/weewx/skins/sqlbackupweek/skin.conf for report sqlbackupweek
May  2 09:53:43 masterofpis weewx[11950]: reportengine: Report sqlbackupweek skipped due to report_timing setting
May  2 09:53:43 masterofpis weewx[11950]: reportengine: Running report sqlbackup
May  2 09:53:43 masterofpis weewx[11950]: reportengine: Found configuration file /home/weewx/skins/sqlbackup/skin.conf for report sqlbackup
May  2 09:53:43 masterofpis weewx[11950]: cheetahgenerator: mem-cg: Memory usage: start 60144 (kb) for sqlbackup
May  2 09:53:43 masterofpis weewx[11950]: cheetahgenerator: using search list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras', 'user.sqlbackup.SqlBackup']
May  2 09:53:43 masterofpis weewx[11950]: sqlbackup: version is 0.3
May  2 09:53:43 masterofpis weewx[11950]: sqlbackup DEBUG: using sql_debug of 4 with weewx.debug of 1
May  2 09:53:43 masterofpis weewx[11950]: sqlbackup DEBUG: starting from 2018-05-01 09:38:43
May  2 09:53:43 masterofpis weewx[11950]: sqlbackup DEBUG: databases, mysql 1 named ['weatherpi']
May  2 09:53:43 masterofpis weewx[11950]: sqlbackup DEBUG: directory for mysql backup files /opt/backups/mysql-backups/20180502
May  2 09:53:43 masterofpis weewx[11950]: sqlbackup DEBUG: processing mysql database, weatherpi
May  2 09:53:43 masterofpis weewx[11950]: sqlbackup DEBUG: dump_file for mysql backup files /opt/backups/mysql-backups/20180502/weatherpi-host.masterofpis-201805020953-daily.gz
May  2 09:53:44 masterofpis weewx[11950]: sqlbackup DEBUG: 0.16 secs to run mysqldump -uXxXxX -pXxXxX -hlocalhost -q  weatherpi archive -w"dateTime>1525131523"  --single-transaction --skip-opt
May  2 09:53:44 masterofpis weewx[11950]: sqlbackup DEBUG: Created /tmp/sqlbackup/weatherpi.inc in 0.04 secs

Back to top

MySQL files:

    
/opt/backups/mysql-backups/20180502

-rw-r--r-- 1 root 117414 May  2 05:53 weatherpi-host.masterofpis-201805020553-daily.gz
-rw-r--r-- 1 root 117045 May  2 06:23 weatherpi-host.masterofpis-201805020623-daily.gz
-rw-r--r-- 1 root 116570 May  2 06:53 weatherpi-host.masterofpis-201805020653-daily.gz
-rw-r--r-- 1 root 116298 May  2 07:23 weatherpi-host.masterofpis-201805020723-daily.gz
-rw-r--r-- 1 root 116110 May  2 07:53 weatherpi-host.masterofpis-201805020753-daily.gz
-rw-r--r-- 1 root 799605 May  2 08:22 weatherpi-host.masterofpis-201805020822-7days.gz
-rw-r--r-- 1 root 116524 May  2 08:23 weatherpi-host.masterofpis-201805020823-daily.gz
-rw-r--r-- 1 root 116742 May  2 08:53 weatherpi-host.masterofpis-201805020853-daily.gz
-rw-r--r-- 1 root 116868 May  2 09:23 weatherpi-host.masterofpis-201805020923-daily.gz
-rw-r--r-- 1 root 116796 May  2 09:53 weatherpi-host.masterofpis-201805020953-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