Wednesday, January 26, 2011

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.

No comments:

Post a Comment