On Thu, Jun 30, 2011 at 13:42, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Jun 30, 2011 at 2:30 PM, Tom Browder <tom.brow...@gmail.com> wrote: ... >> From my limited testing on my web server [temporary files] are >> written in the same directory as the db file, but I would like them to >> be written to a separate directory. ... > See http://www.sqlite.org/tempfiles.html for a list of the various kinds of > temporary files used by SQLite. Some of them (ex: the rollback journal) > must be in the same directory as the database file in order to ensure > recovery after a crash.
Thanks, Richard (and Simon), I think I can solve my web access problem by giving the db file its own directory. Best regards, -Tom P.S. Sqlite seems to be handling my modest multiple-virtual-host Apache2 web server just fine--as expected. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users