vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Switching from Database to File System for attachments (https://vborg.vbsupport.ru/showthread.php?t=153501)

DieselMinded 07-26-2007 09:08 PM

Switching from Database to File System for attachments
 
OK im going to do this can someone tell me the correct steps

Thanks

Kirk Y 07-26-2007 09:11 PM

AdminCP -> Attachments -> Attachment Storage Types -> Move from Database into File System

Create a folder somewhere on your server and CHMOD it to 777, and you're done.

DieselMinded 07-26-2007 09:16 PM

Should i Download the attahment table from php my admin first?

Do i create the folder on my root ? I Know i wont be able to trasfer the files via adminCP with our errors , Shoul i first download the attachment table via phpmy admin and upload it to an ATTACHMENTS folder on my root chmoded to 777?

DM

Kirk Y 07-26-2007 09:54 PM

The directions are simple bud, as outlined in my previous post. Just create a folder anywhere in your webspace; it can be in your root or above your root, though it is good practice to create it above public_html so that attachments can't be downloaded manually.

CHMOD that folder to 777.

Follow my directions in my previous post from here on.

ToKey 07-26-2007 11:24 PM

Hey, I was wanting to do this too, but I can't find the attachments section in the admincp.

Where exactly is it?

Edit: Nevermind, I am a retard. Sorry.

Alfa1 07-26-2007 11:39 PM

What are the (dis)advantages of doing this?

Kirk Y 07-26-2007 11:55 PM

Well the advantages are pretty obvious, if you've got a lot of attachments on your board, moving them from the database to the file system will dramatically reduce the size of your database.

On the other hand, you need to keep regular backups of your forum (You should be doing this already, but some people only back up their database regularly), as your attachments are now stored as files.

DieselMinded 07-27-2007 12:18 AM

Is this a flawless transition?

Kirk Y 07-27-2007 12:22 AM

It was for me.

It's always good practice to make a backup to your database before performing any major switches such as this though.

DieselMinded 07-27-2007 12:29 AM

Understood , But i cant backup Via VBAdmin CP i get errors left and right i have to back up Via PHPmyadmin is there some sort of automated phpmyadmin backup program?

DM


All times are GMT. The time now is 03:31 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01092 seconds
  • Memory Usage 1,722KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete