ich habe irgendwann mal folgendes zum Datenbank-Backup definiert
Code: [Auswählen]
define at_dblog_THBDump at *04:00:00 set Report_DumpsRows dumpMySQL clientSide
attr at_dblog_THBDump alias THBDUMP 4:00
attr at_dblog_THBDump room DBLog,xTimer
# COMMAND set Report_DumpsRows dumpMySQL clientSide
# DEF *04:00:00 set Report_DumpsRows dumpMySQL clientSide
# FUUID 61daea6a-f33f-21fb-b2e6-a7e04cc6a8d5bed2
# NAME at_dblog_THBDump
# NR 46
# PERIODIC yes
# RELATIVE no
# REP -1
# STATE Next: 04:00:00
# TIMESPEC 04:00:00
# TRIGGERTIME 1671418800
# TRIGGERTIME_FMT 2022-12-19 04:00:00
# TYPE at
# READINGS:
# 2022-12-18 20:32:48 state Next: 04:00:00
#
setstate at_dblog_THBDump Next: 04:00:00
setstate at_dblog_THBDump 2022-12-18 20:32:48 state Next: 04:00:00
mein dbrep sieht so aus:
[code]define ReportDbLog_THB DbRep dblog_THB
attr ReportDbLog_THB alias DBRep
attr ReportDbLog_THB room DBLog
# DATABASE fhem
# DEF dblog_THB
# FUUID 639501de-f33f-fd5f-0709-1a9ddf60b65cb43f
# FVERSION 93_DbRep.pm:v8.50.7-s26865/2022-12-17
# LASTCMD initial database connect stopped due to attribute 'fastStart'
# MODEL Client
# NAME ReportDbLog_THB
# NOTIFYDEV global,ReportDbLog_THB
# NR 55
# NTFY_ORDER 50-ReportDbLog_THB
# ROLE Client
# STATE initialized
# TYPE DbRep
# UTF8 0
# HELPER:
# DBLOGDEVICE dblog_THB
# IDRETRIES 3
# PACKAGE main
# VERSION 8.50.7
# READINGS:
# 2022-12-18 23:22:33 state initialized
#
setstate ReportDbLog_THB initialized
setstate ReportDbLog_THB 2022-12-18 23:22:33 state initialized
[/code]
und noch dblog:
[code]define dblog_THB DbLog ./configDB.conf .*:(temperature|power|humidity|va_temperature|va_humidity|humidity_value|desiredTemperature|valveposition|battery|oilfox_metering_liters).*
attr dblog_THB DbLogType Current/History
attr dblog_THB alias dblog_THB
attr dblog_THB asyncMode 1
attr dblog_THB bulkInsert 0
attr dblog_THB cacheLimit 5000
attr dblog_THB commitMode ac:on_ta:off
attr dblog_THB event-min-interval state:600
attr dblog_THB room DBLog
attr dblog_THB syncInterval 30
attr dblog_THB useCharfilter 1
attr dblog_THB verbose 2
# COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
# CONFIGURATION ./configDB.conf
# DEF ./configDB.conf .*:(temperature|power|humidity|va_temperature|va_humidity|humidity_value|desiredTemperature|valveposition|battery|oilfox_metering_liters).*
# FD 5
# FUUID 6395a74c-f33f-fd5f-bf68-e3ca20a9e2cee3df
# FVERSION 93_DbLog.pm:v5.5.3-s26750/2022-12-10
# MODE asynchronous
# MODEL MYSQL
# NAME dblog_THB
# NR 2
# NTFY_ORDER 50-dblog_THB
# PID 750
# REGEXP .*:(temperature|power|humidity|va_temperature|va_humidity|humidity_value|desiredTemperature|valveposition|battery|oilfox_metering_liters).*
# SBP_PID 833
# SBP_STATE running
# STATE connected
# TYPE DbLog
# UTF8 0
# dbconn mysql:database=fhem;host=localhost;port=3306
# dbuser fhemuser
# eventCount 32
# HELPER:
# COLSET 1
# DEVICECOL 64
# EVENTCOL 512
# OLDSTATE connected
# PACKAGE main
# READINGCOL 64
# TC current
# TH history
# TYPECOL 64
# UNITCOL 32
# VALUECOL 128
# VERSION 5.5.3
# OLDREADINGS:
# READINGS:
# 2022-12-18 23:39:17 CacheOverflowLastNum 0
# 2022-12-11 12:26:51 CacheOverflowLastState normal
# 2022-12-18 23:39:17 CacheUsage 15
# 2022-12-18 23:39:17 NextSync 2022-12-18 23:39:47 or when CacheUsage 5000 is reached
# 2022-12-18 23:39:17 state connected
#
setstate dblog_THB connected
setstate dblog_THB 2022-12-18 23:39:17 CacheOverflowLastNum 0
setstate dblog_THB 2022-12-11 12:26:51 CacheOverflowLastState normal
setstate dblog_THB 2022-12-18 23:39:17 CacheUsage 15
setstate dblog_THB 2022-12-18 23:39:17 NextSync 2022-12-18 23:39:47 or when CacheUsage 5000 is reached
setstate dblog_THB 2022-12-18 23:39:17 state connected
[/code]
ist das soweit korrekt ? auch das unspezifische "clientside"
Fehlermeldung bekomme ich nicht direkt; weiß aber auch nicht, wohin das backup geschrieben wird.
bitte um Hilfe
lg
Thomas
habe ich in der falschen Gruppe gefragt?