• ***
  • 128
Transfer Pictures from Database to File System
« on: February 23, 2015, 08:13:55 AM »
Hi Phil,

Could you please answer few questions?

From: http://www.osdateforum.com/general-osdate-help/how-to-administering-osdate-2-xx/15/

Picture Photo Storage

There is a new program available in 2.0, which permits you to change the storage type of uploaded images. To reduce your database server load, you may wish to store images in the file system rather than as "blobs" in the database. The program provided for this is:


To transfer pictures from the database to the File System, start the program using this command (directly type this into your browser bar, relative of course to your osDate root directory):


To transfer pictures from the File System to the database, start the program with this command:


Please note that the action parameter should be as given (upper case).

1, How do I know what storage I am currently running?

2, If I change from Database storage to File storage how will the effect current members photos?

3, Once changed do all future members photos go into the file system?

4, Do I need to create a file folder before running /admin/transferpics.php?action=DB2FS ?

your help greatly appreciated :)



  • *****
  • 2,038
  • osDate Version: osDate Evo v1.0
Re: Transfer Pictures from Database to File System
« Reply #1 on: February 23, 2015, 10:16:06 AM »
Hi Burton,

You have the latest version of osdate v 2.65, that transfer is for the older versions of version osDate v2 with large databases to be converted.

You just need to log into the admin, go to Site Global Settings, at the top dropdown bar pick the Profile Pics and Images
then go to this Images are to be stored in DB? Y Change to N.

That's all there is to it, anyone that uploads a photo will now be stored in the temp/userimages and the temp/cache/userimages
Both of these should be backed up often when you start getting lots of new members.

By changing it to images stored in files, you will save database loading and size plus if you are on a shared host less resources be be used.
Pharg ( Phill )


osDate v2.7 & osDateEvo v1.0 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35



  • ***
  • 128
Re: Transfer Pictures from Database to File System
« Reply #2 on: February 24, 2015, 01:24:31 AM »
Hi Phil,

Great information, thank you :)

Ok I have changed - Images are to be stored in DB? Y Change to N.

So already existing photos will stay in the DB, and all new photos will go into - temp/userimages and the temp/cache/userimages ?

Yes perfect as that was why I wanted to change, to reduce DB size, and reduce resources used.

Thank you :)