Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

Wed, 02 Jan 2013 00:27:18 -0800 

On 12/21/2012 05:18 PM, Dan Kennedy wrote:

Thanks. I think it's this:

  http://www.sqlite.org/src/info/0cfd98ee20

Dan.
Thanks. I have looked into ticket, but we also see this problem when the backup is written and read by the 
same SQLite version (3.7.5).
I have recreated a backup using the 3.7.5 version. These are the hexdumps of both the original file and 
the backup created with SQLite 3.7.5:

The original file:

0000000 5153 694c 6574 6620 726f 616d 2074 0033
0000010 0004 0101 4000 2020 0000 f1d0 0000 7600
0000020 0000 9700 0000 2100 0000 0300 0000 0100
0000030 0000 0000 0000 0000 0000 0100 0000 0000
0000040 0000 0000 0000 0000 0000 0000 0000 0000
0000050 0000 0000 0000 0000 0000 0000 0000 0200
0000060 2d00 1de2 000d 0000 0004 00e3 7202 2002
0000070 7301 e300 0000 0000 0000 0000 0000 0000
0000080 0000 0000 0000 0000 0000 0000 0000 0000

The backup created with SQLite 3.7.5:

0000000 5153 694c 6574 6620 726f 616d 2074 0033
0000010 0004 0101 4000 2020 0000 0100 0000 7600
0000020 0000 9700 0000 2100 0000 0100 0000 0100
0000030 0000 0000 0000 0000 0000 0100 0000 0000
0000040 0000 0000 0000 0000 0000 0000 0000 0000
0000050 0000 0000 0000 0000 0000 0000 0000 0100
0000060 2d00 1de2 000d 0000 0004 00e3 7202 2002
0000070 7301 e300 0000 0000 0000 0000 0000 0000
0000080 0000 0000 0000 0000 0000 0000 0000 0000

--
Regards,
Marco ten Thije
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to