PDA

View Full Version : Database Vs File System


DieselMinded
08 May 2007, 16:41
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
08 May 2007, 22:17
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
08 May 2007, 23:40
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
09 May 2007, 05:19
when you select to do the change, it will prompt you.

for me, i use:

/home/MYSITE/public_html/uploads

and yes, 0777

DieselMinded
09 May 2007, 22:57
How often do you move the files ?

HMBeaty
09 May 2007, 22:59
If you mean backup.....I do it on my site at LEAST once a week. Sometimes more

DieselMinded
10 May 2007, 01:03
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
10 May 2007, 01:04
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
10 May 2007, 01:19
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
10 May 2007, 01:21
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
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

DieselMinded
10 May 2007, 01:24
Path and name of file to save backup to:Your web server must have access to write to this directory (usually chmod 0777)


It has a fansy link in there how do i select my computer?

DM

If I hit go under the list will it promt me to where on my computer i want to put it?

HMBeaty
10 May 2007, 01:41
It has a fansy link in there how do i select my computer?

DM

If I hit go under the list will it promt me to where on my computer i want to put it?
Don't hit go. Use the one right below that

DieselMinded
10 May 2007, 01:56
Warning: The file path specified here will save the backup within the web root, meaning that anybody can download it. We recommend that you specify a more secure location to store your backup.
Path and name of file to save backup to:Your web server must have access to write to this directory (usually chmod 0777)

./forumbackup-xx-xx-xxxx-xxxxxxx.sql

How do i change the field to my computer?

HMBeaty
10 May 2007, 02:03
./forumbackup-xx-xx-xxxx-xxxxxxx.sql

How do i change the field to my computer?
You can't. But IMO, I like using that one a lot better. You just use that one, and download from FTP to your HD