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.
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 ?
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.
04-15-2008, 04:37 PM
Linear Mode
