search

andig / dbcopy

Configurable database backup tool for volkszaehler.org
http://volkszaehler.org
3 stars 4 forks source link

New VZ DB structure need adaption #14

Open fm-maniac opened 1 year ago

fm-maniac commented 1 year ago

The DB structure of VZ has been changed in omitting the auto generated, consecutive ID in favour of a combination of timestamp and channel_ID.

This is very welcome in terms of data efficiency.

Unfortunately dbcopy is not supporting this and instead looking for the old ID as the single primary key. So "pk option" fails on DB backups. Further on "copy option" only executes the first 1000 data sets.

dbcopy needs adaption to the new VZ DB structure.

fm-maniac commented 1 year ago

Just stressing this once again. Hoping to get it fixed/updated. Being unable to start a PR because of lacking knowledge.