Switching from Database to File System for attachments

[DieselMinded]

OK im going to do this can someone tell me the correct steps

Thanks

[Kirk Y]

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]

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]

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]

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]

What are the (dis)advantages of doing this?

[Kirk Y]

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]

Is this a flawless transition?

[Kirk Y]

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]

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