On Wed, Jan 9, 2013 at 6:45 PM, Michai Ramakers <m.ramak...@gmail.com>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
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Reply via email to