<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hallo Andreas,</div>
<div> </div>
<div>hier die dbcopy.yaml:</div>
<div> </div>
<div> </div>
<div>
<div># 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: sqlite.db3 # path is only used if driver = pdo_sqlite<br/>
<br/>
# influxdb target database connection<br/>
influx:<br/>
dsn: influxdb://localhost:8086<br/>
dbname: volkszaehler<br/>
measurement: data<br/>
</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>Beste Grüße</div>
<div> </div>
<div>JD.</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> Saturday, November 07, 2020 at 8:10 PM<br/>
<b>From:</b> "Andreas Götz" <cpuidle@gmail.com><br/>
<b>To:</b> "volkszaehler.org - users" <volkszaehler-users@demo.volkszaehler.org><br/>
<b>Subject:</b> Re: [vz-users] Neubeginn nach Kartencrash</div>
<div name="quoted-content">
<div>Ist ohne Deine Datei schwer zu sagen...<br/>
<div>Viele Grüße,
<div>Andreas</div>
</div>
<div>
<blockquote>Am 07.11.2020 um 18:12 schrieb John Doe <johndoe@null.net>:<br/>
</blockquote>
</div>
<blockquote>
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div> </div>
<div><br/>
Hallo zusammen,</div>
<div> </div>
<div>da ich mir leider doch das Vorgehen vom letzten Mal nicht notiert habe, fehlt mir jetzt wieder der Einstieg.</div>
<div>Ich habe</div>
<div> </div>
<div>- eine Kopie sqlite.db3 der Datenbank</div>
<div>- eine Kopie der vzlogger.conf</div>
<div>- eine Kopie der dbcopy.yaml, mir der ich die Datenbank-Kopie erstellt habe.</div>
<div> </div>
<div>Ich habe</div>
<div> </div>
<div>- das aktuelle VZ-Image installiert und mit Updates versehen</div>
<div>- die Kopie sqlite.dpb3 in das neue Home-Verzeichnis kopiert</div>
<div>- die gesicherte vzlogger.conf und dbcopy.yaml nach /etc kopiert.</div>
<div> </div>
<div>Ein Aufruf von</div>
<div> </div>
<div>sudo /var/www/volkszaehler.org/vendor/bin/dbcopy create -c /etc/dbcopy.yaml</div>
<div> </div>
<div>bringt</div>
<div> </div>
<div>
<div>Creating target schema<br/>
PHP Notice: Undefined variable: schema in /home/pi/volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php on line 155<br/>
PHP Fatal error: Uncaught Error: Call to a member function toSql() on null in /home/pi/volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php:155<br/>
Stack trace:<br/>
#0 /home/pi/volkszaehler.org/vendor/symfony/console/Command/Command.php(255): DatabaseCopy\Command\CreateCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))<br/>
#1 /home/pi/volkszaehler.org/vendor/symfony/console/Application.php(921): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))<br/>
#2 /home/pi/volkszaehler.org/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(DatabaseCopy\Command\CreateCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))<br/>
#3 /home/pi/volkszaehler.org/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Co in /home/pi/volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php on line 155</div>
<div> </div>
<div> </div>
<div>Was mache ich denn diesmal wieder falsch ?</div>
<div>Beste Grüße</div>
<div> </div>
<div>JD.</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div></div></body></html>