Storage in File System rather than MySQL Database Storage in File System rather than MySQL Database
 

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

Storage in File System rather than MySQL Database

Started by CaptainBlue, February 01, 2005, 05:54:10 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

CaptainBlue

I'm planning on running vBulletin and Coppermine on one domain/web site and obviously like the idea of only running one mySQL db, as that's all my hosting package allows.

But...

vBulletin allows for attachments to be stored in the file system rather than the db which is good when you have a 100MB db limit but a 2000MB file limit.

Is there some way that I can accomplish the same thing with Coppermine? Store all the comments and titles, etc. in the db, use the users from the vBulletin bridge feature and not use the db for photo storage?
Richard Morris

Hein Traag

You dont actually store pics in the db. Only the whereabouts of the pictures.

CaptainBlue

Ah! That's great: I read through the manual and couldn't see that. vBulletin has the option to store attachments in the file system or db (db as default) so I thought Coppermine's default was in the db.

That's good news. Thanks for the help.
Richard Morris

CaptainBlue

Quote from: CaptainBlue on February 01, 2005, 06:33:56 PM
I read through the manual and couldn't see that.

QuoteThe album directory
This is the base directory for your "Image Store". The path is relative to the main directory of the script.

You can use ../ in the path to move-up one level in the directory tree.

You can not use an absolute path there ("/var/my_images/" will not work) and the album directory must be visible by your web server.

The directory for user files
This is the directory where files uploaded with the web interface are stored. This directory is a subdirectory of the album directory.

The same remarks as above apply.

When you upload files by FTP, store them in a subdirectory of the "album directory" and not inside the "directory for user files".

:-[
Richard Morris

Hein Traag