On Wed, 4 Feb 2009 17:55:38 -0500, "D. Richard Hipp"
<d...@hwaci.com> wrote in General Discussion of SQLite
Database <sqlite-users@sqlite.org>:

>The hot backup API has not yet been released.  Look for version 3.6.11.
>
>If you open your database using the special name ":memory:" then it is  
>held entirely in memory with no duplication of pages (accept as  
>required to support ROLLBACK).  Such a :memory: database is initially  
>empty, of course.  So then initialize it  from a file using the backup  
>API.

Very nice to see it will also be available in the command
line tool:

sqlite> .help
.backup ?DB? FILE   Backup DB (default "main") to FILE

.restore ?DB? FILE  Restore content of DB
               (default "main") from FILE

http://www.sqlite.org/draft/sqlite.html

>D. Richard Hipp
>d...@hwaci.com
-- 
  (  Kees Nuyt
  )
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to