Yes, it is envisaged.

2007/10/2, Beber <[EMAIL PROTECTED]>:
>
> Hi,
>
> For doing some backup for my own purpose I was in need to backup a
> sqlite file. I get some interesing results.
>
> This sqlite is about 20 MB and 164913 lines :
>
> % ls -lh /var/spool/bogofilter/wordlist.db
> -rw------- 1 mail mail 20M 2007-10-02 11:11
> /var/spool/bogofilter/wordlist.db
>
> After having compress it, it is :
>
> % cp /var/spool/bogofilter/wordlist.db /tmp
> % bzip2 -9p /tmp/wordlist.db
> % ls -lh /tmp/wordlist.db.bz2
> -rw------- 1 root root 6.0M 2007-10-02 12:30 /tmp/wordlist.db.bz2
>
> Size decrease by about a factor 3. Not so bad. Then see next phase.
>
> Then, I tried to dump base :
>
> % sqlite3 /var/spool/bogofilter/wordlist.db .dump > /tmp/wordlist.sqlite
> % ls -lh /tmp/wordlist.sqlite
> -rw-r--r-- 1 root root 15M 2007-10-02 12:33 /tmp/wordlist.sqlite
>
> After compressing it (just text there) :
>
> % bzip2 -9p /tmp/wordlist.sqlite
> % ls -lh /tmp/wordlist.sqlite.bz2
> -rw-r--r-- 1 root root 1.1M 2007-10-02 12:33 /tmp/wordlist.sqlite.bz2
>
> Here we decrease the size by ~19 the original size !
>
> Maybe could we use that way in the else repo managment ?
>
> --
> Beber
>
>


-- 
====
Eric PINCON

Reply via email to