A cli app to run mysqldump and store it into s3
- Setup your aws credentials & config like in this guide
- Install mysql cli tools, specifically mysqldump
Install this package globally using your preferred package manager
npm install -g mysql-to-s3
or
yarn global add mysql-to-s3
Add a mysql instance to be backed up
mysql-to-s3 add
Remove instance that you dont want to backup
mysql-to-s3 remove
List instances
mysql-to-s3 instances
List backups that have been created
mysql-to-s3 list
Create backup of the instances you added before
mysql-to-s3 run --bucket <bucket name>
To change tmp dir, you can set it in MYSQL_TO_S3_TMP environment variable.
MYSQL_TO_S3_TMP=/path/to/other/dir