Delete campain from command line

twisted1919

Administrator
Staff member
not from mailwizz, but you can do it from command line:
Code:
# 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.
 

twisted1919

Administrator
Staff member
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.
 
Top