Delete campain from command line

[Uroš]

Hey

Is there a way to delete campains older then x days true command line.

Thank you
U

 

[twisted1919]

not from mailwizz, but you can do it from command line:

# login
mysql -u MAILWIZZ_USER -p

# use mailwizz database
use DATABASE_NAME;

# show tables and identify the campaigns table
show tables;

#delete campaigns older than may 2015
DELETE FROM mw_campaign WHERE DATE(date_added) < '2015-05-01';

Keep in mind that deletion can take even hours.

 

[Uroš]

Great thank you will do that from phpmyadmin

BR
U

 

[twisted1919]

I wouldn't do it from phpmyadmin. As i said, it can even take hours and phpmyadmin will timeout. That's why command line is safer.

 

[Uroš]

Thank you for info. Have small amount of campains.

BR
U