HELP!! MYSQL Database Question?? HELP!! MYSQL Database Question??
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

HELP!! MYSQL Database Question??

Started by tcr1016, April 19, 2008, 04:02:55 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

tcr1016

I am installing oppermine and need to know if it uses alot of MYSQL space? My web host only allows 100mb of MYSQL space. Does the gallery store data in the MYSQL or just in the total webspace?? My webspace is 400G. Do I need more MYSQL or is 100mb more than enough? Where is all the users, pics, and thumbnails stored??

Thank you for your help.

tfischer

Pics (including thumbnails) are stored in your webspace (albums folder).  Pretty much everything else is stored in the database.  But you'd have to have a pretty huge gallery with large captions on each picture to begin to eat up that space...

-Tim

Joachim Müller

Let me give you an example of the mySQL resources consumption: on my personal gallery with 13636 files in 318 albums and 31 categories with 308 comments viewed 557889 times the mySQL tables take up 76 MB. Coppermine stores the files you upload on the webspace. Only the path to the file is stored in the database, which are only a few bytes per record. However, the setup your webhost provides is ridiculous: 400 GB of webspace is a huge number that doesn't work well with such a small sized mySQL database.