DEV Community

Discussion on: Backup Postgres to S3

View post

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

Collapse
 
maxborysov profile image
Max Borysov • • Edited

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