!MySQL Database size exceeded!

[popustda]

Hello guys,
Can someone please help me with this. I reached my limit of 1GB and i dont know why my _banner_stat_ is 0,9GB big. What is inside it and how can i clean it without damaging my webshop?
i am attaching the pic so you can see my problem.
Please some1 help me solve this

[abolabo]

you can remove data from this table manually, via phpMyAdmin.
just run

Code Select Expand

DELETE FROM 9u9_banner_stat;

[popustda]

and this will not affect my website functionality?

[Basara]

The DELETE statement is used to delete records from a table. So your banner statistics will be removed.
Please backup before run this query

[helperbee]

I think I should clear out Banner Statistics now that the shop is live so that we have more accurate view and conversion count.

Is the new name of the table ab_banner_stat?  My version of AbanteCart is 1.2.2.

If so, then is this the correct command to clear the table? (Yes, my first time using phpMyAdmin).

DELETE FROM ab_banner_stat;

I couldn't find another way from the Admin Dashboard to reset the banner stats. Thanks for your assistance.

[abolabo]

we already added this functionality in our todo-list. Will be