rjobaan
Posts: 53
Joined: Sun Aug 18, 2013 1:07 pm

Combine Domoticz.db

Thu Dec 17, 2015 12:03 pm

Now I finally succeeded in making backups how can How can I combine those db files into one?
I have SQL Light running

User avatar
DougieLawson
Posts: 39182
Joined: Sun Jun 16, 2013 11:19 pm
Location: A small cave in deepest darkest Basingstoke, UK
Contact: Website Twitter

Re: Combine Domoticz.db

Thu Dec 17, 2015 12:41 pm

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.
Note: Any requirement to use a crystal ball or mind reading will result in me ignoring your question.

Criticising any questions is banned on this forum.

Any DMs sent on Twitter will be answered next month.
All non-medical doctors are on my foes list.

Return to “Networking and servers”