On Feb 4, 2009, at 5:48 PM, Nicolas Williams wrote:
> On Wed, Feb 04, 2009 at 05:19:13PM -0500, D. Richard Hipp wrote:
>> http://www.sqlite.org/draft/c3ref/backup_finish.html
>
> Does this work at the page level? Or can one have pre-created the
> destination DB with a different page size than the source DB?
>
It does a binary copy - so you cannot change the page size on the
fly. If you want a backup with a different page size, first make the
backup, then change the page size on the backup using:
PRAGMA page_size=NEWSIZE;
VACUUM;
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
