Automatic MySQL / PostgreSQL Backups with a Shell Script and Cron Job скачать в хорошем качестве

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