Page 1 of 1

Combine Domoticz.db

Posted: Thu Dec 17, 2015 12:03 pm
by rjobaan
Now I finally succeeded in making backups how can How can I combine those db files into one?
I have SQL Light running

Re: Combine Domoticz.db

Posted: Thu Dec 17, 2015 12:41 pm
by DougieLawson
SQLite3 has a dump command. I don't know whether that will be in your "SQL Light" version.

Code: Select all

.dump ?TABLE? ...      Dump the database in an SQL text format
                         If TABLE specified, only dump tables matching
                         LIKE pattern TABLE.
you can use the .dump command to extract data for reloading into another database.