Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: !MySQL Database size exceeded!  (Read 5295 times)

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
!MySQL Database size exceeded!
« on: September 21, 2015, 05:47:09 AM »
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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: !MySQL Database size exceeded!
« Reply #1 on: September 21, 2015, 07:10:12 AM »
you can remove data from this table manually, via phpMyAdmin.
just run
Code: [Select]
DELETE FROM 9u9_banner_stat;
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: !MySQL Database size exceeded!
« Reply #2 on: September 21, 2015, 10:55:08 AM »
and this will not affect my website functionality?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: !MySQL Database size exceeded!
« Reply #3 on: September 22, 2015, 01:56:05 AM »
The DELETE statement is used to delete records from a table. So your banner statistics will be removed.
Please backup before run this query

Offline helperbee

  • Jr. Member
  • **
  • Posts: 78
  • Karma: +2/-0
    • View Profile
Re: !MySQL Database size exceeded!
« Reply #4 on: October 02, 2015, 12:04:12 PM »
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.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: !MySQL Database size exceeded!
« Reply #5 on: October 02, 2015, 03:54:53 PM »
we already added this functionality in our todo-list. Will be
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod