vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   increase database capacity (https://vborg.vbsupport.ru/showthread.php?t=176233)

GSMata 04-15-2008 05:28 PM
increase database capacity
 
how i can dont allow to save in my mysql database or increase my database capacity ?

soundbarrierpro 04-15-2008 05:37 PM
? mysql is infinite. There is no cap.

GSMata 04-15-2008 06:36 PM
i want to remove save attach in sql and other way that increase my sql database

soundbarrierpro 04-15-2008 06:40 PM
save attach? Stop users from uploading attachments?

Lynne 04-15-2008 07:19 PM
You can move your attachments to the filesystem by going to Admin CP > Attachments > Attachment Storage Type and moving them to the filesystem there.

Quote:
Switching Attachments from the Database to the File System and vice-versa This process will allow you to move your attachments from the database into the file system, or, if they are in the file system, to a different directory in the file system or back into the database. Please note that if you do not have enough disk space in the intended destination, the process will fail, but your attachments will be safe as tests are done first to ensure there is enough space.
Attachments will not be removed from the database or filesystem and your storage type setting will not be changed until the end of the process.
If the process aborts before the end, you will need to free up space or prune attachments before trying again.

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.

If you are moving attachments from the file system into the database, you must have enough storage space on the drive and/or partition where your database is located.

GSMata 04-15-2008 08:11 PM
my host supporter tell me that my sql database have big storage and is have pressure on host
and i must decrease this sql and move something from it
how i can do it ?

Lynne 04-15-2008 10:29 PM
Quote:
Originally Posted by GSMata (Post 1491543)
my host supporter tell me that my sql database have big storage and is have pressure on host
and i must decrease this sql and move something from it
how i can do it ?
I just posted how to move your attachments out of the database and into the filesystem. After you move them out of the database, make sure to do a repair/optimize on the attachment table (Admin CP > Maintenance > Repair/Optimize Tables) so the database size goes down.


All times are GMT. The time now is 03:03 AM.

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.01079 seconds
  • Memory Usage 1,725KB
  • 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
  • (7)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