Help! Device gone in Domoticz, how to restore that device's historic data from old backup?

[andrehj]

Somehow a device with a lot of historic data is no longer present in Domoticz (also in Setup → Devices) . Don't understand how that happened, I must have deleted it accidentally...

From the output of scripts I can see that it's missing since the 8th of June.
I have a domoticz_backup.db from June 2nd.

Is it possible to retrieve the device data (table) from that old backup and somehow insert it into my current database? Is there a how-to which explains how to do that? From my scripts I know the correct Device Idx.

From other devices and scripts I can estimate the values of the missing days. It would be nice if I could insert these into the table as well. But how do I accomplish that?

Thanks in advance for any help,

Andrehj

[waltervl]

See the database merge tool mentioned in this topic: viewtopic.php?p=312243#p312243

[Varazir]

See the database merge tool mentioned in this topic: viewtopic.php?p=312243#p312243

I can't download the file

https://releases.domoticz.com/releases/ ... BMerger.7z

[jvdz]

Try: https://releases.domoticz.com/release/t ... BMerger.7z

[Varazir]

Try: https://releases.domoticz.com/release/t ... BMerger.7z

Thanks it worked, It looked strange at first but didn't try to remove the extra.

[andrehj]

See the database merge tool mentioned in this topic: viewtopic.php?p=312243#p312243

Thanks for the help!

However, as far as I understand, that tool can only merge some specific tables, or all tables. I just need to gather my historic data from one specific Idx, and integrate that into the current database.
I don't understand how I can do that with this tool.

Do I have to simply run
DomoticzDBMerger.exe --inputdb=olddatabase.db --outputdb=currentdatabase.db --merge-all
and hope that it works?

Or can I use the command
--transfer-old=idx --transfer-new=idx
to copy one idx from the old db to the current db? And than by keeping the idx the same it should just copy that index?
DomoticzDBMerger.exe --inputdb=olddatabase.db --outputdb=currentdatabase.db --transfer-old=137 --transfer-new=137

And will the latter work if a device with the new index is not yet present in the output database? Or do I have to create it first and let the merger simply fill that data?

So many questions...

Too bad there is no more elaborate help for this tool.