On 11 Apr 2011, at 2:04am, Samuel Neff wrote: > I'm interested in hearing anyone's experiences of using WAL journal mode on > technical support. We often have to copy databases to attach to customer > reports and if the someone were to copy the database file while there is an > active -wal file then we would very likely be missing the most up-to-date > data in the copy. I'm not sure if we can rely on support to issue a pragma > wal_checkpoint prior to doing the copy.
My understanding is that no matter what journaling mode you're using, a straight copy of the data file is not 'safe' while the database is open. If you want to backup the data, keep the database closed, or use the special SQLite backup API. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
