My database is over quota...?

[VIPguard]

Hi!

I have a little big problem, my database is over quota (149mg / 100mg) this cause a fatal error. My server provider can not lift my quota. What can I do to resolve that?

Thank's!!!!!

[Hein Traag]

Post a link to your cpg site. Also, which host are you with?

[VIPguard]

this is the link: http://www.vipguard.net/galeries/index.php
and I'm host by 1and1.com

[Hein Traag]

It shows a Fatal Error when i go to that address.

[VIPguard]

Yes this is my problem!

[François Keller]

wich tables are the bigest in your database ?

[VIPguard]

Coppermine

[Hein Traag]

Which tables of coppermine are the biggest..

[VIPguard]

it not only use one?
if not how can I identify?

[François Keller]

you must use a tool like phpmyadmin to see all tables used by coppermine in your database (they are 21 tables in a "normal" coppermine install)

[VIPguard]

Table: cpg133_exif              Total 116 564 Ko
Table: cpg133_hit_stats       Total 32 043 Ko

The others are more small....

[Nibbler]

You can empty the exif table and disable exif in config and you can empty the hit stats table and disable hit stats in config.

[VIPguard]

What is the use of this two?

[Nibbler]

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_logging_hitdetails
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_picture_thumb_advanced_exif

[VIPguard]

Ok the exif is all information on a picture and the hit I suppose it's the number of hit each picture...

You are sure I can empty a db without problem... I don't know db... and I don't want lost all...

Do you have an other solution for my problem if I don't want to clear this db?

[Nibbler]

Nobody is telling you to empty the db. You should empty just those two tables as suggested. If you don't know what you're doing make a backup first or ask your host to help you.

[VIPguard]

Yes I understand, s'cuse my english is not very well...

But else to empty those 2 tables, other solution are possible or not? Like use 2 bd?

[Fabricio Ferrero]

Like use 2 bd?

No, do as suggested

[phill104]

Something sounds odd here to me. 1&1 provide 100MB of space for DB's and you have supposedly used 149MB. Deleting 116 564 Ko + 32 043 Ko is not going to equate to 49MB.

Given that you have 116k of exim data and assuming that every pic has exim data then you probably have around 1500 pics on your install?

Surely nowhere near enough to fill a 100MB database?

[VIPguard]

22 174 lines in exif table