Re: [sqlite] Dump a memory DB

On 31 Oct 2012, at 2:25pm, Andrea Peri wrote: > From the sqlite3 console, is possible to dump on disk a memory DB ? Use the .dump command. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Dump a memory DB

You can use the .backup command: http://www.sqlite.org/sqlite.html *Jonas Malaco Filho* 2012/10/31 Andrea Peri > Hi, > > From the sqlite3 console, is possible to dump on disk a memory DB ? > > Thx, > > -- > - > Andrea Peri > . . . . . . . . . > qwerty

[sqlite] Dump a memory DB

Hi, >From the sqlite3 console, is possible to dump on disk a memory DB ? Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] dump in-memory db to file in tcl

Hello! 1. Use tcl backup API The "backup" method The "backup" method makes a backup copy of a live database. The command syntax is like this: dbcmd backup ?source-database? backup-filename The optional source-database argument tells which database in the current connection should be backed

Re: [sqlite] dump in-memory db to file in tcl

Ned Fleming wrote: > Is it possible to dump an in-memory sqlite database (or table?) to a > file from within Tcl? > > I create it like so: > > sqlite3 dbFireData :memory: > > and insert a bunch of records, and then commit. Is there reason not to attach a file (old or new), and either

[sqlite] dump in-memory db to file in tcl

Is it possible to dump an in-memory sqlite database (or table?) to a file from within Tcl? I create it like so: sqlite3 dbFireData :memory: and insert a bunch of records, and then commit. I have tried the following (and variations) -- but no go, kokomo. ($fileOut3 is a handle to a