Question asked by ellisfr - February 6, 2016 at 2:29 PM
I noticed one of my users has a 500 MB mailinglist.db in his domain folder.
Is there a way to "reset" or shrink this mailinglist.db file ? I guess it keep tracks of various sends but he only uses mailing list as alias.
Thank you !

2 Replies

Reply to Thread
Matt Petty Replied
February 8, 2016 at 8:53 AM
Employee Post
You should be able to open the db file with a tool like http://sqlitebrowser.org/ (It's what I use) and clear some space by executing these commands in the Execute SQL tab.
delete from BounceLog;

delete from MessageLog;
Make sure to Write Changes when you are done. You may want to backup this file before performing this action as well, just in case anything bad happens.
EDIT: Also doing File > Compact Database can drop the size by a large amount. Thanks ellisfr.
Matt Petty
Software Developer
SmarterTools Inc.
(877) 357-6278
Paul Blank Replied
February 8, 2016 at 10:52 AM
That is very good info to have.  Thanks for posting! 

Reply to Thread