3
mailinglist.db
Question asked by ellisfr - 2/6/2016 at 2:29 PM
Answered
Hello,
 
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 !
 

5 Replies

Reply to Thread
2
Matt Petty Replied
Employee Post Marked As Answer
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
www.smartertools.com
0
ellisfr Replied
Thank you Matt, I will try that.
0
ellisfr Replied
I did the delete but saw the size didn't change much.
I then used the "Compact Database" option in the file menu and my mailinglist.db file went from 476 MB to... 63 KB ;-)

Thank you !
0
Paul Blank Replied
That is very good info to have.  Thanks for posting! 
0
Matt Petty Replied
Employee Post
I'm glad that helped, I never had to do that to the DB file before so I was kinda taking a swing with the "delete from" but the Compact Database is something I missed.
Matt Petty
Software Developer
SmarterTools Inc.
(877) 357-6278
www.smartertools.com

Reply to Thread