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