How to edit sending quota for a client from DB?

[Niko]

Hello,
after a mistake, we noticed that the sending quota for a client has been reset. This is a big client that send thousands of emails, so we would need to edit his sending quota

to make the numbers match again.

Is there a way to do this from database? Where is this number stored, and how can we edit it?
Thanks.

 

[Niko]

Hi @twisted1919 you can help on this?
Thx

 

[twisted1919]

@Niko - the quota is created in realtime based on the records from delivery_server_usage_log so if you have reset the quota, there's really no way to put it back..

 

[Niko]

If I restore the table from backup of mysql?

 

[twisted1919]

That will do it most likely.