how big a part does the mysql database play in this how big a part does the mysql database play in this
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

how big a part does the mysql database play in this

Started by syvers, December 15, 2003, 10:45:43 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

syvers

My webspace only allows one database which is already beig used so i need to know if i have to create a new table in the database which coppermine uses, i also need to know what it stores as the size is only 100mb i dont think it would be wise to have the images stored in there so do they get stored in a folder on the web directory.

Thanks
Syvers

Joachim Müller

there's no need for an additional mySQL database, you can use an existing one. Coppermine install will create several tables in the existing database, each of them with a prefix you can choose during installation ("cpg11d_" by default), which will result in these tables being created:
  • cpg11d_albums
  • cpg11d_banned
  • cpg11d_categories
  • cpg11d_comments
  • cpg11d_config
  • cpg11d_exif
  • cpg11d_pictures
  • cpg11d_usergroups
  • cpg11d_users
  • cpg11d_votes[/list:u]The pictures themselves will not be stored inside the database, only the locations (folders, filenames and some other stuff coppermine needs to keep track of things). You won't have to be afraid that your database becomes too huge (on my page, the coppermine tables use 1.285 MB space for more than 5,000 pics) - if I were you, I'd worry about the webspace, not the db size. After installing coppermine, it's a good idea to experiment with the config settings to see how the resolution and quality settings affect the usage of webspace before going "live".

    GauGau

syvers