Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 25 Nov 2011, 20:36
thermax04 thermax04 is offline
 
Join Date: Apr 2011
What effect the dataBase size?

Dear All
I have a new forum (7 month old), Iam using MySQLDumper to do the Backups, I noticed that DataBase file size is increasing day after day. which is normal.
I want to know which factors effect the size: no. of threads or posts , or the size of the thread (words, pics) or the size of attachments? or what?
Reply With Quote
  #2  
Old 25 Nov 2011, 21:51
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
All of those will effect the size. Of course, large attachments can really effect the size of the database which is why it's recommended to not store them in the database if you have a lot of attachments or large attachments (in which case you will need to back up the attachment directory).
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 25 Nov 2011, 22:23
thermax04 thermax04 is offline
 
Join Date: Apr 2011
90% of my attachments are uploaded to upload sites, but I can not force users to do the same, and pics are needed for explanations.
Reply With Quote
  #4  
Old 26 Nov 2011, 01:22
setishock setishock is offline
 
Join Date: Feb 2008
If you move the attachments to the file system it's totally transparent to the members.
ACP > Attachments > Attachment Storage Type
BACK UP YOUR DATABASE FIRST!!!

However if you and your members are just linking to an outside source this will have little to no effect.
__________________
Working on new projects and expanding our horizons. Come by and see what we're up to now.
Reply With Quote
  #5  
Old 26 Nov 2011, 07:47
thermax04 thermax04 is offline
 
Join Date: Apr 2011
My ACP Attachment settings says ;
Attachments are currently being stored in the database

What is the meaning of Moving the attachments to the file system?
is it the Hosting site?

the help file says:

If you are moving attachments into the file system, it is recommended that you do *not* place the folder under your web root (usually named public_html or www or www_root) because people will be able to bypass vBulletin's permission system and download them. Also, you will need to make the folder writeable by PHP. The easiest way to do this is CHMOD it 777 (consult your FTP, Telnet, or SSH documentation for more info on how to do this). We do not recommended that you put a folder that is CHMODed 777 under your web root - another good reason to have it located above the document root

Iam a new in Forums CP, I did not understand what it means
Is there any special steps need to be done first?
Is there any side effects on any other settings?
Please advice and explain to a non expert person at all
Reply With Quote
  #6  
Old 26 Nov 2011, 16:12
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
https://www.vbulletin.com/docs/html/attachment_storage
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 10:30.

Layout Options | Width: Wide Color: