From the course: Red Hat Enterprise Linux 8 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Perform logical database backups

Perform logical database backups

From the course: Red Hat Enterprise Linux 8 Essential Training

Start my 1-month free trial

Perform logical database backups

“

- [Instructor] There are two types of backups for database servers, physical and logical. Backing up database servers can be complex, because traditional backup tools focus on physical files on the server. However, backing up files on a working database server can result in corrupted database files, if file system snapshots are not employed as a database is changing while it's being backed up. A physical database backup stores the physical files on the server, and as such it includes the server configuration and the database files themselves. This type of a backup would be good for re-creating an entire database server from scratch. In contrast, a logical database backup is carried out by having the database service export its data resulting in SQL files that can later be imported. This type of backup does not include the server configuration files, and is good for moving data in a database from one database server to another, or for replicating the database. Let's see how this works.…

Contents