load sqlite.db into rqlite

[James Reilly]

Feeling like a bit of a dope but i cant find the syntax for loading up the lead database with an existing sqlite database.

I assume that it is an option?

Cheers

/jpr

[Philip O'Toole]

Here you go: https://github.com/rqlite/rqlite/blob/master/DOC/RESTORE_FROM_SQLITE.md

--
You received this message because you are subscribed to the Google Groups "rqlite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rqlite+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rqlite/de51d52d-9e2a-4a70-a456-a7c82150777dn%40googlegroups.com.

[James Reilly]

cheers for the quick response.  Regrettably i am using a windows machine and your instructions work properly for my bash cloud production system but not my local one.

After a bit of testing I think that sqlite has a set of commands that provide the same function https://www.sqlitetutorial.net/sqlite-dump/

sqlite> .output c:/fn.sql  

sqlite> .dump 

sqlite> .exit

I changed the output name to fn.dump... not sure if this is relevant or not.

[James Reilly]

further to my last email i just loaded the .dump file into rqlite with the rqlite.exe command line... works like a charm

rqlite

.schema

+-----+

| sql |

+-----+

.restored fn.dump

.schema

+------------- a whole bunch of stuff..... 

___+

select * from tbl_persons ;  

...etc

[Philip O'Toole]

Great, good luck.

To view this discussion on the web visit https://groups.google.com/d/msgid/rqlite/ab950198-1a81-43c6-8163-23a6cbb710b7n%40googlegroups.com.