MySQL - delete from mailing_tbl where mailinglist_id='32'

[economicist]

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:

Code: Select all

mysql> delete from mailing_tbl where mailinglist_id='32';

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?

[maschoff]

The OpenEMM extension architecture documentation provides an explanation of the database schema.

BTW, if you are not sure about the consequences of a SQL statement you should try it first on a copy of the real database.