result of sqlite3 --> db conversion
    Saša Janiška 
    sjaniska at gmail.com
       
    Fri Jan 10 19:13:46 CET 2020
    
    
  
Hello,
I did not want to maintain my own sqlite3-based version of bogofilter and
therefore converted it to *.db with:
sqlite3 --> db:
bogoutil -d .bogofilter/wordlist.db >.bogofilter/wordlist.txt
import into db:
bogoutil --db-transaction=yes -l .bogofilter/wordlist.db <.bogofilter/wordlist.txt
Now, wordlist.db was timmed from 1.3G to 609M, but after conversion I'm left
with some extra files:
$ ls -l                                                                     
total 4,8G
-rw-r--r-- 1 gour gour 344K sij  10 19:00 __db.001
-rw-r--r-- 1 gour gour  40K sij  10 19:00 __db.002
-rw-r--r-- 1 gour gour  48K sij  10 19:00 __db.003
-rw-r--r-- 1 gour gour    0 sij  10 15:51 lockfile-d
-rw-r--r-- 1 gour gour 1,0K sij  10 18:48 lockfile-p
-rw-r--r-- 1 gour gour 1,0M sij  10 19:00 log.0000001749
-rw-r--r-- 1 gour gour 609M sij  10 15:56 wordlist.db
...
and I wonder if I should keep those __db.*, lockfile-* and log.* files?
When I verify db with:
$ bogoutil --db-verify .bogofilter/wordlist.db
it exits without any warning and
$ db_verify ~/.bogofilter/wordlist.db                                                  
BDB5105 Verification of /home/gour/.bogofilter/wordlist.db succeeded.
so I wonder if everything is OK and if it is possible to get rid of those extra
{__db.*, lockfile-*, log.*} files?
I'm using bogofilter-1.2.5 along with Claws-Mail on Manjaro (Arch) Linux.
Any hint?
Sincerely,
Saša
 
-- 
As the ignorant perform their duties with attachment to results,
the learned may similarly act, but without attachment, for the
sake of leading people on the right path.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <https://www.bogofilter.org/pipermail/bogofilter/attachments/20200110/6cc535ab/attachment.sig>
    
    
More information about the bogofilter
mailing list