backup
The process of copying some or all table data and metadata from a MariaDB instance, for safekeeping. Can also refer to the set of copied files. This is a crucial task for DBAs. The reverse of this process is the restore operation.
With MySQL, physical backups are performed by the MySQL Enterprise Backup product, and logical backups are performed by the mysqldump command. These techniques have different characteristics in terms of size and representation of the backup data, and speed (especially speed of the restore operation).
Backups are further classified as hot, warm, or cold depending on how much they interfere with normal database operation. (Hot backups have the least interference, cold backups the most.)
See also cold backup.
See also hot backup.
See also logical backup.
See also MySQL Enterprise Backup.
See also mysqldump.
See also physical backup.
See also warm backup.