| #!/bin/sh | |
| # | |
| # Script to prepare and restore full and incremental backups created with innobackupex-runner. | |
| # | |
| # This script is provided as-is; no liability can be accepted for use. | |
| # | |
| INNOBACKUPEX=innobackupex-1.5.1 | |
| INNOBACKUPEXFULL=/usr/bin/$INNOBACKUPEX | |
| TMPFILE="/tmp/innobackupex-restore.$$.tmp" |
| #!/bin/sh | |
| TMPFILE="/tmp/innobackupex-runner.$$.tmp" | |
| USEROPTIONS="--user=XXX --password=XXX" | |
| FILTERTABLES="--include=.*[.].*" | |
| BACKDIR=/var/mysql-bak | |
| BASEBACKDIR=$BACKDIR/base | |
| INCRBACKDIR=$BACKDIR/incr | |
| FULLBACKUPLIFE=3600 #604800 # How long to keep incrementing a backup for, minimum 60 | |
| KEEP=1 # Keep this number of backups, appart form the one currently being incremented |
This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)
Sister Document - Restore MySQL from Amazon S3 - read that next
this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc
| // | |
| // TransitionController.h | |
| // | |
| // Created by XJones on 11/25/11. | |
| // | |
| #import <UIKit/UIKit.h> | |
| @interface TransitionController : UIViewController |