filmov
tv
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:
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:
---
Follow along?
Hit the subscribe button to receive more videos like this!
---
Code:
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:
---
Follow along?
0:25:10
Automatic MySQL / PostgreSQL Backups with a Shell Script and Cron Job
0:13:44
Automatic PostgreSQL Database Backups
0:04:12
PostgreSQL Tutorial: Automate Backup & Restore with Bash Script (Hands-On)
0:01:01
Windows : how to backup postgresql database automatically on daily basis?
0:02:09
PostgreSQL backup and restore a database with pgAdmin 4
0:20:48
Back Up Your MySQL Databases! (Spoiler: It's Easy)
0:14:21
Understanding Backups of SQL Server, MySQL, PostgreSQL in GCP Limitation of Automated and OnDemand
0:02:49
PostgreSQL Backups & Restores - ScaleGrid
0:00:39
What is the purpose of Amazon RDS? #aws #cloudstorage #cloudtutorial #quiz #TechShorts #CodingTips
0:05:50
PostgreSQL vs MySQL | A Comprehensive comparison
0:23:11
How to Backup/Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’
0:01:31
How to Take AWS RDS Backup | Automated Snapshot and Manual Snapshot
0:05:31
Schedule Automatic Backups for PostgreSQL with pgAgent in pgAdmin
0:03:03
Google Cloud Backup and DR - Using PostgreSQL backups to mount or restore a database
0:04:59
Google Cloud Backup and DR - Adding and backing up PostgreSQL databases
0:01:37
How to backup PostgreSQL databases using SQLBackupAndFTP
0:03:40
Scheduled PostgreSQL backups using pgAdmin and pgAgent
0:05:10
#How To take #Backup & #Restore database backup #Postgresql
0:14:37
AWS RDS Backup Retention: How to Retain MySQL & PostgreSQL Database Data for Over 35 Days.
0:15:57
RDS Backup/Restore with AWS Backup Service
0:27:30
How to backup PostgreSQL (using wal-g)
0:15:12
Postgresql - Automatic Backup (.sql, .custom) with Cronjob in Centos 7
1:33:38
Setting Up and Scheduling Regular PostgreSQL Backups - PostgreSQL Database Backup Tutorial
0:04:51
backup restore postgreSQL 15 database in pgadmin 4 postgreSQL tutorial explained
Комментарии