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

Matt Petty Replied

2/8/2016 at 8:53 AM

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

ellisfr Replied

2/8/2016 at 9:28 AM

Thank you Matt, I will try that.

ellisfr Replied

2/8/2016 at 9:41 AM

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 !

Paul Blank Replied

2/8/2016 at 10:52 AM

That is very good info to have. Thanks for posting!

Matt Petty Replied

2/8/2016 at 12:14 PM

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

Back to Community Threads

Please leave this box unchecked

5 Replies

Reply to Thread

Tags

Related Knowledge Base Articles