Bulk update Delivery Servers (Daily Quota)

sendmedialtd

Active Member
Hey,

I've just added 20 new delivery servers to my MailWizz app and I'm wanting to Warm the IPs up, each day im going to have to manually update eavery delivery server with its new Daily Quota. Thats time consuming when in the end im going to be having over 200 delivery servers. So i thought the better way for me doing this would be to directly run a SQL Query which would update them all at the same time. Before i go ahead and do this can you confirm that there isnt any other record in the database that I'd need to update too please.

Code:
UPDATE mw_delivery_server
SET daily_quota = 100
WHERE customer_id = 1
AND server_id IN (31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50);

If you could let me know that would be great.

Thanks,
Mike
 
Last edited:
Back
Top