On Feb 4, 2009, at 5:51 PM, Eric Minbiole wrote: > > "If the source database is modified [...] then the backup will be > transparently restarted by the next call to sqlite3_backup_step()" > > Does this mean that the backup is restarted *to the beginning*, or > is it > able to re-copy only those pages which have just been modified?
That depends. If the change was made using the same database connection that was passed into sqlite3_backup_init(), then only those pages that changed are recopied. However, if an independent database connection made the change, then the backup process has no way of knowing exactly which pages changed, so it has to start over again from the beginning. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
