Best way for deleting 26.000 contacts of Mautic?

Product Support
1

Your software
My Mautic version is: 3.25
My PHP version is: 7.4
My Database type and version is: 10.2.40

Your problem
My problem is:

Which is the best way for deleting 26.000 contacts from Mautic? With the less impact in the server if possible.

These errors are showing in the log:

Steps I have tried to fix the problem:

2

Truncate (empty) the leads table via Phpmyadmin

image
image2688×180 70.9 KB

1 Like
3

I wrote a command to delete contact based on contact ID. :rofl:

1 Like
4

Thanks @EJL will try this way. :slightly_smiling_face:

1 Like
5

Hi @gordon.hu I have not so much experience in commands about Mautic, so I will be doing as @EJL suggested.

Thanks anyway.

1 Like
6

another way to go about doing this is to create a segment with all the contacts you want to delete.
Then go and create a campaign that starts with that segment and use the Action Delete Contact.

That will do the job as well.

2 Likes
7

Hi Mikew, good point.

I don´t know why I don´t think in that way but you are right.

Thanks for sharing. :wink:

8

The first thing we’re prompted to do is to choose a contact source. In our case, our source of leads is coming from a segment. Find and select the segment that contains the contacts that you wish to see deleted from your database.

1 Like
9

Thanks @kevin_david_k for your answer.

More ways to solve it.

Have a good day.

The question is solved and I was personally able to delete all contacts.

Thank you all for your answers.