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