vb.org Archive - Going from Database Storage to File System.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Going from Database Storage to File System. (https://vborg.vbsupport.ru/showthread.php?t=73967)

BlackxRam

01-07-2005 09:27 PM

Going from Database Storage to File System.

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 08:24 PM

Quote:

Originally Posted by BeePee

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 09: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

Quote:

Originally Posted by AN-net (Post 591912)

is this option only possible though through admincp options and debug mode is on?

No. its available anytime

All times are GMT. The time now is 09:35 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01466 seconds Memory Usage 1,723KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: