On Mon, Sep 6, 2010 at 7:21 PM, Richard <t...@usa.com> wrote:
> Hi,
>
>
> I was wondering if there's a method to directly load a disk DB into memory.
> I'm aware of 2 indirect methods, namely:
>
>
> - create a .dump and .read the created file
>
>
> - attach the disk DB and insert the disk tables into memory tables
>
>From the command-line shell, us:
.restore ?DB? FILE
Where DB is the name of the memory database ("main" if you started the shell
with "sqlite3 :memory:") and FILE is the name of the file that contains your
data.
>From an application use the sqlite3_backup() interface (for which the
".restore" command is a wrapper).
>
>
> I'm using the command line tool. Is there a direct method for this?
>
>
> Thanks,
>
>
> Richard
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
