News for hackers. Stuff that matters.

Ask HN: How do you backup your DB?

Feel free to include where your db is stored (bare metal, cloud, managed), how often, how you do it and a short story about recovering your db.
( 3 comments | 5 points | on HN )
Re:Ask HN: How do you backup your DB? by codegeek on Sunday June 05, 2016 @10:37AM (#11841175)
1. mysqldump.... > $curr_date/backup.sql

2. aws s3 sync $curr_date s3://mybucket

The 2 steps above go into a crontab.

Re:Ask HN: How do you backup your DB? by kull on Saturday June 04, 2016 @07:58AM (#11836012)
Hosting on digital ocean, backup on S3 Amazon, hourly database backup.
Re:Ask HN: How do you backup your DB? by element121 on Saturday June 04, 2016 @06:11PM (#11838373)
Rackspace cloud, backed up via CodeGuard to Amazon S3 daily.