Any recommended ways to reduce the Mailwhizz MySQL Database Size?

[Alex N]

Hello,

The mySQL database I'm using for Mailwhizz is now 6 GB in size...

I was thinking...

Is there any easy ways to clean that up? Anything I could do without
screwing up anything?

 

[frm.mwz]

Hello,

The mySQL database I'm using for Mailwhizz is now 6 GB in size...

I was thinking...

Is there any easy ways to clean that up? Anything I could do without
screwing up anything?

if you use InnoDB, use individual tables, they can be optimized/reduced

 

[twisted1919]

@Alex N / @frm.mwz - You can always delete old campaigns if you don't need them. That will clear a lot of data. Secondly, you can use the campaigns-archive-command to archive sent campaigns, as described here.

 

[Ignacio Jimenez Torrado]

Hello, I´ve done what you suggested here: https://kb.mailwizz.com/articles/archive-campaigns-delivery-logs/ and now I´m getting an error:

CDbException
CDbConnection failed to open the DB connection.

 

[Ignacio Jimenez Torrado]

OK, I restarted mysql and now It´s working again.