Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a website (a digital asset management system/gallery - http://www.resourcespace.org) that has a huge amount of images. The total size of the website, including the images is approximately 6gb.

The website is in PHP and uses a MySQL database.

What is the best way to automatically backup the website & MySQL database and push to Amazon S3 each night?

Are there any readily available scripts out there that can do this?

share|improve this question

migrated from stackoverflow.com Oct 9 '12 at 4:02

This question came from our site for professional and enthusiast programmers.

    
Just found this if anyone is interested... looks quite good & will investigate website2backup.com –  user991830 Mar 28 '12 at 9:09
    
I develop website2backup.com :) The problem is the 6gb it is huge, too big for PHP. As PHP cannot manipulate files of more than 2gb the archive cannot be completed. If you really want to use a PHP solution you must do several backups of your website. For example if your gallery is organized by months do a backup for each month. The incremental files backup functionality of W2B allow you to use less storage and resources, but a full backup is regularly needed. Adding files to archives can be resources consuming for your web hosting, smallest archives do faster backups. –  Axel Mar 28 '12 at 12:54
1  
@Axel - PHP on a 64bit system can handle files more than 2GB in size. –  Jamie Mar 29 '12 at 10:46
add comment

1 Answer

I have not yet dealt with size of data that you are referring to. However, I did find this handy script and tweaked it to push my backup files to Amazon S3.

https://github.com/woxxy/MySQL-backup-to-Amazon-S3

If you have not already seen the recent announcement for Amazon Glacier, you should take a look. It may be more along the lines of what you need for pure backups.

http://aws.amazon.com/glacier/

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.