How to backup mysql database to amazon s3 ?

[Administrator]

Any idea ? how we can backup mysql database to amazon s3. I need to backup my wordpress website database on amazon s3.

[Jayant R. Danech]

Hi,

A plugin can be used to backup your complete Wordpress to Amazon S3 storage.. Details on how to do that is as follows:

ON WORDPRESS DASHBOARD:

• After installing and activating the BackupBuddy plugin, visit the Remote Destinations page.
• Click the +Add New tab to add your new Amazon S3 destination.

• On the next screen, follow the steps to finish connecting your Amazon S3 account to BackupBuddy.

AWS PANEL:

• Log in to the Amazon Web Console. From the top menu, select Services then click IAM.
• From the left menu, select Users or go to https://console.aws.amazon.com/iam/home#users.
• Click the Create New Users button.
• Enter a username you wish to create to give access to your bucket. For example, you might use "backup_24x7".
• Click Show User Security Credentials to display them. This is the Access Key and Secret Key you will enter into BackupBuddy when creating the Amazon S3 Remote Destination.

ON WORDPRESS DASHBOARD:

• Go back to the dashboard and enter those details from Amazon that are required into the BackupBuddy. Click Close to move on.
• Click the username you just created to open its details.
• Copy the following Security Policy into your favorite text editor:

--------------------------------------- ---------------------------------------
{
"Version": "2018-10-04",
"Statement": [
{
"Effect": "Allow",
"Principal": {
"AWS": [
"YOUR_USER_24x7_HERE"
]
},
"Action": "s3:*",
"Resource": [
"24x7:aws:s3:::YOUR_BUCKET_NAME_HERE",
"24x7:aws:s3:::YOUR_BUCKET_NAME_HERE/*"
]
}
]
}

--------------------------------------- ---------------------------------------

• Copy the text to the right of User ARN; it will look something like arn:aws:iam::1234567890:user/backup_24x7.
• Paste this User Arn, replacing "YOUR_USER_24x7_HERE" in the Security Policy above that you pasted into your text editor.
• Replace "YOUR_BUCKET_NAME_HERE" with the name of your Amazon S3 Bucket you want to grant this user access to.

In AWS PANEL:

• From the top menu select Services then click S3 or go to URL https://console.aws.amazon.com/s3/home
• Click the bucket you want to grant access to.
• In the upper right of this screen, make sure the Properties tab/button is selected so you see bucket details on the right.
• Expand Permissions and click Edit bucket policy.
• Paste the Security Policy from your text editor in this box.
• Click Save.

You can now start sending your WordPress backups to Amazon S3 destination with BackupBuddy.