A Simple collection of scripts to create MySQL backups on PagodaBox and sync them to S3. Blogged about here: http://www.matthewfordham.com/blog/pagodabox-backup.
- http://sourceforge.net/projects/automysqlbackup
- https://github.com/yellowandy/s3sync
- http://aws.amazon.com/sdkforphp/
- Add your database credentials to
scripts/mysql_dump.sh - Add your S3 credentials to
scripts/s3sdk/config.inc.php - Adjust the Cron jobs in the Boxfile to suit your needs and S3 bucket.
- Make sure you have a shared writeable directory in the Boxfile for wherever
scripts/mysql_dump.shis set to dump to.