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
From the course: Red Hat Enterprise Linux 8 Essential Training
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 encrypted database files if file system snapshots are not employed as the 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 recreating an entire database server from scratch. In contrast, a logical database backup is carried out by having the database service export as 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
Database services introduction44s
-
(Locked)
Install and configure MariaDB2m 3s
-
(Locked)
Manage SELinux for database services2m 58s
-
(Locked)
Perform logical database backups4m 5s
-
(Locked)
Create a database with tables4m 37s
-
(Locked)
Restore logical database backups2m 17s
-
(Locked)
Perform simple SQL queries3m 1s
-
(Locked)
Perform logical database backups4m 5s
-
(Locked)
Restore logical database backups2m 17s
-
(Locked)
Recover the MariaDB root password2m 47s
-
(Locked)
Set the root database password2m 8s
-
-
-
-
-
-
-
-