In this recipe, you will learn how to perform a scheduled backup of your MySQL database and upload it to Amazon S3.
To complete this recipe, you will need an application with a MySQL cartridge. Please refer to the Adding a MySQL cartridge to your application recipe of this chapter to learn how to install the MySQL cartridge. Also, you need to have an Amazon AWS account. Visit http://aws.amazon.com/, and sign up for a new account if you don't have one already.
Follow these steps to schedule a daily backup of your MySQL cartridge:
Go to https://console.aws.amazon.com/s3/home, and create a new bucket to store your database backups.
Add a
cron
cartridge to your application by running the following command:$ rhc add-cartridge cron --app myapp
SSH into the application gear, and download the
s3-bash
utility in$OPENSHIFT_DATA_DIR
. Then, extract it to thes3-bash
directory by running the following commands:$ rhc ssh --app myapp...