MYSQL Database Limit Exhausted - I can't login to Admin Area

[Frank Duru]

Hello All,

I noticed that I couldn't be able to login into the backend (Admin area) of my flynax site and forms like privacy policy returns error message on a quick registration form. I began to look for the issue and find out that the MYSQL Database Limit Exhausted. So I contacted my host and I was informed that this is the normal behavior of their system when database entries outgrow the DB set limit. In my case the set limit is 1000 MB but the DB suddenly grow 1048 MB in size. I was also informed by the host support team that they cannot do anything. I should find a way to reduce the size to gain back the admin access.

Now my problem is how I can clean/purge the DB to reduce the size or is there another way to fix this issue since I don't have access to the admin area? How could one avoid this in the future?

My site is Auto software 4.7.1 with Auto nova template. I attached a file that shows the error message.

Thanks in advance.

Best regards