SyntaxPilot
Courses/SQL and Databases/Lesson 72
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

SQL and Databases · Lesson 72 of 90

Operations: backups, recovery and schema migrations

backuplogical backup (pg_dump, mysqldump, .dump)physical backupSQLite .backup / VACUUM INTOpoint-in-time recovery (PITR)RPORTOrestore testingschema migrationmigration tools (Alembic, Flyway, Liquibase)up/down migrationszero-downtime migrationexpand-and-contract

Detailed notes for this lesson are being written. They appear here together with the video.