DEV Community

Discussion on: Backup Postgres to S3

Collapse
iamkarshe profile image
Utkarsh Kumar Raut

Thanks for the share!
Same way one can automate the backups for MySQL — using mysqldump.

Collapse
maxborysov profile image
Max Borysov • Edited on

yeap, I do exactly the same :) Having a bash script with mysqldump and then upload to s3.

Collapse
iamkarshe profile image
Utkarsh Kumar Raut

Our Complete Automation Template

  1. Cron runs at every 12th hour. crontab
  2. Run script (mysqldump) to make backup
  3. Trigger script (php) to sync backup with Google Cloud Storage
  4. If all good all fine, we trigger another script (php) for Slack notification to our dev team