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!!!!!
Post a link to your cpg site. Also, which host are you with?
this is the link: http://www.vipguard.net/galeries/index.php
and I'm host by 1and1.com
It shows a Fatal Error when i go to that address.
Yes this is my problem!
wich tables are the bigest in your database ?
Coppermine
Which tables of coppermine are the biggest..
it not only use one?
if not how can I identify?
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)
Table: cpg133_exif Total 116 564 Ko
Table: cpg133_hit_stats Total 32 043 Ko
The others are more small....
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.
What is the use of this two?
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
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?
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.
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?
QuoteLike use 2 bd?
No, do as suggested ;)
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?
22 174 lines in exif table
The show stopper probably is the stats table. You shouldn't have enabled stats recording in the first place if you have no idea on the impact. You should have emptied the stats on a scheduled basis. Ranting about the size of the exif table is invalid as well.
Now stop whining and do as suggested:
- Turn of the recording of detailed stats in coppermine's config
- Turn off the population of exif information in coppermine's config
- Backup your entire database using phpMyAdmin or mySqlDunmper. If you have no idea how to accomplish that: hire a freelancer or ask your webhost for support -> no support from us
- Empty (not delete!) the table that contains your stat details using phpMyAdmin. Do not delete the entire database - just empty the table! If you have no idea how to accomplish that: hire a freelancer or ask your webhost for support -> no support from us
- Empty (not delete!) the table that contains your exif data using phpMyAdmin. Do not delete the entire database - just empty the table! If you have no idea how to accomplish that: hire a freelancer or ask your webhost for support -> no support from us
This thread looks like a parody of the bad joke of the type "
Help, doctor: whenever I hit myself on the head with a baseball bat it hurts so badly". You know what the doctor will reply: "
well, then don't hit yourself in the first place". :D