Backing Up MySQL Databases to Amazon S3

Here is a pretty straight forward method for backing up MySQL databases to Amazon S3.

I use webmin to backup MySQL databases on a Linux system. I use a simple backup that runs every day at midnight. I backup the databases to a databases folder on the same machine.

See http://webmin.com for more info on webmin. Note: we install webmin on all our systems.

I use a backup script setup in crontab to run every morning at 6:00 AM. The s3fs file is a shell script that uses rsync to make incremental backups to my Amazon S3 account. See This blog by John Eberly on creating a backup script to Amazon S3.


This is my Amazon S3 account with my backup databases.

See Amazon’s S3 pricing. You get 5 Gigabytes of free storage.

For implementing your own Ubuntu system with all kinds of options for your business, i.e. SugarCRM, vTigerCRM, BigBlueButton, MediaWiki, SPC-INTRANET, Drupal, or something you would like to use like a scheduling software, contact us for a free consultation.

S P C Intranet Slideshare

Check out this SlideShare Presentation:

S P C Intranet Slideshare

View more presentations from SPC-INTRANET.

SPC-INTRANET My Files Directory

I like the My Files feature of our intranet site. Our clients can access their files over the Internet, and our search feature is excellent for locating files and directories quickly. You can search, zip and download a directory with sub-folders. You can also setup a customer or vendor account for sharing files too.