MySQL - delete from mailing_tbl where mailinglist_id='32'
Posted: Wed Oct 31, 2012 5:41 pm
I am the new email campaign administrator at my company, and thousands of our older mailings were sent on another server using OpenEMM 5.5.1. I have been asked to collect statistics related to those mailings.
On that server, instead of using "test recipients", the company tested emailings by actually scheduling and sending them to a mailing list (which has openemm.mailinglist_tbl.mailinglist_id = '32') including a few people at the company. There are now over 1300 test mailings like this, and I would like to delete them all in order to clean up the list of mailings. Using the online GUI to do this will take weeks since loading the list of mailings after deleting one takes nearly 10 minutes.
I have just been granted access to the OpenEMM MySQL database, and am considering running the following code:
I thought I should ask someone familiar with OpenEMM if I could do this. Would this be OK, or would it be a catastrophically bad idea? If the latter is true, is there a better idea?
On that server, instead of using "test recipients", the company tested emailings by actually scheduling and sending them to a mailing list (which has openemm.mailinglist_tbl.mailinglist_id = '32') including a few people at the company. There are now over 1300 test mailings like this, and I would like to delete them all in order to clean up the list of mailings. Using the online GUI to do this will take weeks since loading the list of mailings after deleting one takes nearly 10 minutes.
I have just been granted access to the OpenEMM MySQL database, and am considering running the following code:
Code: Select all
mysql> delete from mailing_tbl where mailinglist_id='32';