Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Storage in File System rather than MySQL Database  (Read 3059 times)

0 Members and 1 Guest are viewing this topic.

CaptainBlue

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
    • Captain Blue's Page o' Crap
Storage in File System rather than MySQL Database
« on: February 01, 2005, 05:54:10 pm »

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?
Logged
Richard Morris

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Storage in File System rather than MySQL Database
« Reply #1 on: February 01, 2005, 06:10:51 pm »

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

CaptainBlue

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
    • Captain Blue's Page o' Crap
Re: Storage in File System rather than MySQL Database
« Reply #2 on: February 01, 2005, 06:33:56 pm »

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.
Logged
Richard Morris

CaptainBlue

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
    • Captain Blue's Page o' Crap
Re: Storage in File System rather than MySQL Database
« Reply #3 on: February 01, 2005, 06:47:26 pm »

I read through the manual and couldn't see that.

Quote
The 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".

 :-[
Logged
Richard Morris

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Storage in File System rather than MySQL Database
« Reply #4 on: February 02, 2005, 11:59:17 am »

 :-[ <-- why the sad face ?
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 15 queries.