servers

Notes and simple tutorials related to linux server administration tasks.

How to backup a MySQL database to Amazon Simple Storage Service (S3)

How to backup a MySQL database to Amazon Simple Storage Service (S3)

One of my projects is running on a Digital Ocean VPS, deployed there using Laravel Forge (an amazing tool which automates a lot of painful server-related tasks). Although I have enabled the backup service offered by Digital Ocean, I needed to create an additional off-site backup solution for the project’s database, so I decided to store them in AWS S3 service. This small tutorial covers the task of creating a shell script that will automatically backup a MySQL database to a set of AWS S3 buckets.

Read more →