On Wed, Jan 9, 2013 at 6:45 PM, Michai Ramakers <[email protected]>wrote:
> I will now try to make it a bit smaller for mailing. Where can I put/send
> it?
>
This doesn't answer your question, but your question got me thinking about
using SQL to back up or "vacuum" repos...
stephan@tiny:~/cvs/fossil$ gzip -c fossil.fsl > fossil.fsl.gz
stephan@tiny:~/cvs/fossil$ l fossil.fsl*
-rw-rw-rw- 1 stephan stephan 35969024 Jan 8 17:55 fossil.fsl
-rw-rw-r-- 1 stephan stephan 30286793 Jan 9 18:53 fossil.fsl.gz
stephan@tiny:~/cvs/fossil$ echo '.dump' | sqlite3 fossil.fsl > fossil.sql;
l fossil.sql; gzip fossil.sql; l fossil.sql.gz
-rw-rw-r-- 1 stephan stephan 46902857 Jan 9 18:54 fossil.sql
-rw-rw-r-- 1 stephan stephan 24109773 Jan 9 18:54 fossil.sql.gz
that SQL file, which is slightly smaller than fossil.fsl.gz, can then be
fed back into sqlite3 to recreate the repo:
stephan@tiny:~/cvs/fossil$ zcat fossil.sql.gz | sqlite3 foo.fsl; mkdir foo;
cd foo
stephan@tiny:~/cvs/fossil/foo$ l ../foo.fsl
-rw-r--r-- 1 stephan stephan 29767680 Jan 9 18:56 ../foo.fsl
stephan@tiny:~/cvs/fossil/foo$ f open ../foo.fsl | tail
www/wikitheory.wiki
project-name: Fossil
repository: /home/stephan/cvs/fossil/foo/../foo.fsl
local-root: /home/stephan/cvs/fossil/foo/
project-code: CE59BB9F186226D80E49D1FA2DB29F935CCA0333
checkout: 0fb6c829f2dbf6580315c05eb6c854065d1b9267 2013-01-08 16:55:39
UTC
parent: be93ecb3a5758b84592f6fb0249420744f10c5ca 2013-01-08 15:58:42
UTC
tags: trunk
comment: Added missing commit example to 5-minute quickstart. (user:
stephan)
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
