Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 21 Jun 2007, 16:16
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Backing up Attachments

I'm interested to hear other admins methods of backing up their attachments folder.

My site runs on two servers - one is the webserver, the other is for mysql. My attachments are stored in the file system on the main webserver. Currently, we have a bit over 4.2 GB in attachments. My method of backing them up is to do a backup of that folder once a week in the middle of the night (that is the lowest activity for us) using a cron job I wrote. All it does is tar the attachment folder and then put that backup in the backup folder on that server. Then, I manually go and scp a copy over to the mysql server every week. So, we end up with two copies of the backup - one on each server.

I just know there must be a better way to do this. It seems kinda stupid to make a whole tar of the folder every week when most of those attachments stay the same. Does anyone have a better script to use to do their backups? Or a better suggestion on how to handle their attachments?

Thanks for any input.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Comments
  #2  
Old 23 Jun 2007, 03:42
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
No one has any comments about this? I know other sites must backup their attachments using some method.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 26 Jun 2007, 20:27
COBRAws's Avatar
COBRAws COBRAws is offline
 
Join Date: Oct 2002
Real name: Jack
I just FTP orSSH and download them to a backup server.
__________________
cobraws
Reply With Quote
  #4  
Old 26 Jun 2007, 20:29
da420 da420 is offline
 
Join Date: Nov 2005
I just gzip the folder via SSH, and download via FTP.
Reply With Quote
  #5  
Old 26 Jun 2007, 21:35
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn Hinckley
I moved all my attachments to file system and I backed them up using FTP
Reply With Quote
  #6  
Old 27 Jun 2007, 15:44
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
I have them in the file system, but we are talking about over 4 GB worth of attachments (and getting bigger every day). I figured some of you guys with big boards would also have this same 'problem'.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #7  
Old 27 Jun 2007, 15:47
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn Hinckley
vB.org uses file system, I wonder how that works... :|
Reply With Quote
  #8  
Old 27 Jun 2007, 16:43
Bigblah Bigblah is offline
 
Join Date: Mar 2006
I've done an update of a mirror of my attachments by accessing the backup server via SSH and running wget with the -N option (and -r and -l for recursive retrieval). wget can connect through FTP so you can point it to your attachment directory.

With that many attachments though, having wget retrieve every directory filelisting and check timestamps would certainly be a time consuming process.
Reply With Quote
  #9  
Old 08 Jul 2007, 01:30
Angel-Pie Angel-Pie is offline
 
Join Date: Apr 2007
i havent done any backing up yet, just getting the board together and then will back up the files but thanks for all the ideas!
Reply With Quote
  #10  
Old 08 Jul 2007, 10:47
orban orban is offline
 
Join Date: Jan 2005
I rsync them to another server, smooth and painless. You can't possible gzip and download 5gb of attachments every couple days so we had to find another way.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 11:56.

Layout Options | Width: Wide Color: