<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Hi,<div>sorry so weit habe ich nicht gelesen.<br>Bei der Installation werden meiner Meinung nach Demo-Daten angeboten. Hast du diese probiert? Dbcopy braucht sehr lange, aber ein Fortschritt sollte erkennbar sein..</div><div><br></div><div>Eventuell ist DB auch kaputter wie du denkst.</div><div><br><div dir="ltr">Thomas <div><br></div></div><div dir="ltr"><blockquote type="cite">Am 17.08.2021 um 14:38 schrieb John Doe <johndoe@null.net>:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div style="font-family: Verdana;font-size: 12.0px;"><div>Hallo Thomas,</div>
<div> </div>
<div>wie ich unter 7. schrieb hatte ich source und target in der dbcopy.yaml vor dem copy getauscht. Aber nochmal zur Eindeutigkeit:</div>
<div> </div>
<div>Mit dieser dbcopy.yaml</div>
<div> </div>
<div>
<div>pi@raspberrypi:~ $ cat /etc/dbcopy.yaml<br>
# DATABASE DEFINITION<br>
target:<br>
driver: pdo_mysql<br>
host: localhost<br>
user: root<br>
password: demo<br>
dbname: volkszaehler</div>
<div>source:<br>
driver: pdo_sqlite<br>
host: localhost<br>
user: root<br>
password: raspberry<br>
dbname: volkszaehler_backup<br>
path: /home/pi/sqlite.db3 # path is only used if driver = pdo_sqlite</div>
<div># influxdb target database connection<br>
influx:<br>
dsn: influxdb://localhost:8086<br>
dbname: volkszaehler<br>
measurement: data</div>
<div># TABLE DEFINITION<br>
# ----------------<br>
# tables will be processed in the order they are mentioned:<br>
# - foreign keys on target will be dropped<br>
# - if a table is not listed here, it will not be touched<br>
# transfer mode<br>
# skip: table will not be copied<br>
# copy: entire table will be truncated on target and copied from source<br>
# pk: selective copy by primary key. only data not present on target<br>
# will be copied from source.<br>
tables:<br>
entities: copy<br>
properties: copy<br>
entities_in_aggregator: copy<br>
data: pk<br>
aggregate: skip</div>
<div> </div>
<div> </div>
<div>ergibt sich das genannte Symptom.</div>
<div>Grüße</div>
<div> </div>
<div>JD.</div>
<div> </div>
<div> </div>
</div>
<div> </div>
<div> </div>
<div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Sent:</b> Tuesday, August 17, 2021 at 2:29 PM<br>
<b>From:</b> "Thomas Höpfner" <thomas@thhoe.de><br>
<b>To:</b> "volkszaehler.org - users" <volkszaehler-users@demo.volkszaehler.org><br>
<b>Subject:</b> Re: [vz-users] Datenbank-Umzug auf neuen Raspi schlägt fehl</div>
<div name="quoted-content">
<div>
<div>deine <span style="font-family: Verdana;font-size: 12.0px;background-color: rgb(255,255,255);">dbcopy.yaml </span>ist noch vom Backup
<div> </div>
<div id="AppleMailSignature">Thomas
<div> </div>
<div> </div>
</div>
<div>
<blockquote>Am 17.08.2021 um 14:18 schrieb John Doe <johndoe@null.net>:<br>
</blockquote>
</div>
<blockquote>
<div>dbcopy.yaml</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div></div>
</div></blockquote></div></body></html>