Log in

View Full Version : Going from Database Storage to File System.


BlackxRam
01-07-2005, 09:27 PM
Does switching from Database storage to File System Storage Lose any data? Or does it place those image names into a folder on your server? Reason I am asking is Im trying to lower load on my mysql database because right now all avatars and attachments are kept on the mysql database. Will everything be intact if I change to file system?

lasto
01-07-2005, 09:45 PM
you can go right ahead and do it m8.I did it the other week and all it does is store the attachements in folders on the main server.

Marco van Herwaarden
01-08-2005, 06:29 AM
You will not loose any data.

- It will make your database much smaller, reducing the risk of timeouts if you do a webbased backup.
- You will need to backup the folder containing the attachments from filesystem.

Paul M
01-08-2005, 10:43 AM
We did this a few days ago and I'm not aware of any lost data. :)

AN-net
01-08-2005, 12:33 PM
is this option only possible though through admincp options and debug mode is on?

BeePee
01-09-2005, 02:57 PM
create a directory on your server: your_forum_url/any_directory_you_like/
and chmod it to 777

AdminCP -> Attachments -> Attachment Storage Type:

Move Items from Database into File System

Set the path to the server internal path not the url of above directory.

debug mode has no effect on this.

auz1111
08-30-2005, 09:24 PM
create a directory on your server:

Set the path to the server internal path not the url of above directory.



good info... i was unsure how to specify the path

RaidenDAWG2
08-31-2005, 10:13 PM
This actually recovered some stuff for me...

Had both avatars and attachments stored in the DB until today (didn't know there was another way to do it til about 20 minutes ago). Well, two weeks ago, we moved to a new server, and our avatars got messed up. Moved them to the file system today, everything's working fine now.

vspro
12-14-2006, 05:34 PM
So sorry I see error you can help me

http://www.vbulletin.com/forum/showthread.php?t=212562

Ntfu2
12-14-2006, 07:09 PM
is this option only possible though through admincp options and debug mode is on?

No. its available anytime