6 terms
The binary log is the MySQL and MariaDB record of every committed data change, used for replication and for point-in-time recovery after a backup.
A database dump is an export of a database's schema and data into a portable file that can recreate the database on another server or in…
A database snapshot is a point-in-time image of a database's data, used for fast backups, cloning and recovery to that exact moment.
mysqldump is the command-line client that creates logical backups of MySQL and MariaDB databases as SQL statements that can be replayed to restore the data.
pg_dump is the PostgreSQL utility that creates a consistent logical backup of one database as an SQL script or an archive restorable with pg_restore.
Point-in-time recovery restores a database to its exact state at a chosen moment by replaying transaction logs on top of an earlier full backup.