Скачать или смотреть Automatic MySQL / PostgreSQL Backups with a Shell Script and Cron Job

We'll cover backing things up on a custom schedule and restoring from a backup.

Hit the subscribe button to receive more videos like this!

---

Code:

https://gist.github.com/nickjj/00b07e...

Timestamps:

0:00 -- What we'll be covering in this video
0:44 -- Sendy is the app we're backing up, which uses MySQL / MariaDB
1:44 -- Using mysqldump to save a compressed version of the database backup
4:00 -- Parsing out DB credentials from a file using grep, cut and sed
8:20 -- Demonstrating how the backup script works when calling it manually
9:32 -- Scheduling the backup to happen once a day with a cron job
12:13 -- Creating a separate backup rotation cron job to delete old backups
14:20 -- Going over how mtime works and how to set a custom time for testing
16:23 -- Creating another script to restore your database
22:02 -- Modifying things for PostgreSQL
22:51 -- When disaster strikes it's nice to have scripts to help restore things quickly
23:30 -- Potentially modifying things to write to block storage or an S3 bucket

Reference links:

https://sendy.co/?ref=6L8Qf (affiliate link)
https://www.digitalocean.com/?refcode... (affiliate link and you get $100 in credits)
https://crontab.guru

---

Follow along?

Personal Website: https://nickjanetakis.com
Twitter:   / nickjanetakis