I am recently using phpList version 3.6.8, with MySQL 8. After my first newsletter send to an old list of 200,000 Yahoo email addresses, about 25,000 wrong addresses resulted. For all these addresses the message was:
Subject: Undelivered Mail Returned to Sender
554 30 Sorry, your message to firstname.lastname@example.org cannot be delivered. This mailbox is disabled (554.30). (in reply to end of DATA command)
I would like to remove all these addresses from the database so that the next time the newsletter is sent, only the correct addresses will be sent.
Can I do this directly from MySQL? Or do I have to take each error message and delete from the phpList GUI one by one each wrong email address?
What could be the SQL command that I should run in the MySQL database to delete all these wrong addresses at once? Or else, what is the table and columns in the database where these wrong e-mails are registered.
Such a solution would be of great use to me (and I hope for others too). Thanks.