Portable only to other machines with similar hardware and software.Backups can include log and configuration files.Consist of raw copies of database directories and folders.Physical backups have these characteristics: Backups do not include log or configuration files.Backup is slower because the server must access database information and convert it to a logical format.Logical backups are highly portable, and can be restored to another database provider (such as Postgres) in some cases.The database structure is retrieved by querying the database.Logical backups have these characteristics: Logical backups export information and records in plain text files, while physical backups consist of copies of files and directories that store content. Performing backups enables a system administrator to recover data after several types of events: The database often contains most of a company’s mission-critical data (sales, clients, etc.). It is very important to back up MariaDB databases, and databases in general.
0 kommentar(er)
