View Full Version : Database Vs File System
DieselMinded
05-08-2007, 02:41 PM
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
05-08-2007, 08:17 PM
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
05-08-2007, 09:40 PM
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
05-09-2007, 03:19 AM
when you select to do the change, it will prompt you.
for me, i use:
/home/MYSITE/public_html/uploads
and yes, 0777
DieselMinded
05-09-2007, 08:57 PM
How often do you move the files ?
HMBeaty
05-09-2007, 08:59 PM
If you mean backup.....I do it on my site at LEAST once a week. Sometimes more
DieselMinded
05-09-2007, 11:03 PM
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
05-09-2007, 11:04 PM
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
05-09-2007, 11:19 PM
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
05-09-2007, 11:21 PM
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
05-09-2007, 11:24 PM
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
05-09-2007, 11:41 PM
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
05-09-2007, 11:56 PM
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
05-10-2007, 12:03 AM
./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
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.