Database Vs File System

How Should I store Items ?

And where do i select the path ?

If i Click attachment Storage type it just asks if i want to move items from the database to the file system ...well OK but where do i set the file paths and ect I know they have to be chmoded 777 i can do this ,

So I need to create Folders on the sever for Avatars , Ect..ect.... and chmod them 777 then set the path (SOMEWHERE?) then click move items from server to file system , now how are these backed up ? i just sync with my local computer and store the images on an external harddrive here ?

I want to keep my sql clean Tell me how/if i should do this Please

DM

[briansol]

file system is more efficient at storing files, but it makes backups a little more difficult, and keeping items secure (ie, you can browse to the folder) is sometimes an issue.

That said, i use the file system, and would never consider the databaste for images, ever, under any circumstances.

you can make the folder where ever you want. I use "/uploads/" on most my sites.

to back up, yes, just FTP in, and download... or, get a server with a NAS option backup, and SSH in and set your backup task to point to the nas /sda6 or whatever it may be.

[DieselMinded]

Where DO I set the path ?

Then I need to Chmod 777 an uploads folder on the sever then i can click move to files ..Right?

[briansol]

when you select to do the change, it will prompt you.

for me, i use:

/home/MYSITE/public_html/uploads

and yes, 0777

[DieselMinded]

How often do you move the files ?

[HMBeaty]

If you mean backup.....I do it on my site at LEAST once a week. Sometimes more

[DieselMinded]

My server Guys told me the database is Backed up every night , Is there something addionally you do ?

If I move the Items from the database to files then once a week i need to go in and click move to files right?

DM

[HMBeaty]

Originally Posted by DiesellMinded

My server Guys told me the database is Backed up every night , Is there something addionally you do ?

If I move the Items from the database to files then once a week i need to go in and click move to files right?

DM

Yes. I would also have a database backup of your own on your hard drive made at least once a day

[DieselMinded]

Can you Guide me on how to Back the database up on my computer ? Do I do this through the Control panel at the server ?

Also My Host wont install GB or Image Magic Or Give me a dedicated sever so i will be moving after the first of the year is this a huge deal?

And Thanks I will set up a folder Chmoded 777 on file path /backup

Which would be just a back up folder on the main index right?

Sorry for the questions things are going good for my site and i just want to secure the future

DM

[HMBeaty]

Originally Posted by DiesellMinded

Can you Guide me on how to Back the database up on my computer ? Do I do this through the Control panel at the server ?

Admincp > Maintenance > Database Backup

Originally Posted by DiesellMinded

Also My Host wont install GB or Image Magic Or Give me a dedicated sever so i will be moving after the first of the year is this a huge deal?

No. Just transfer all of your files over and make sure you have a backup of the database and restore the database to the new host