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.
Restore logical database backups
From the course: Red Hat Enterprise Linux 8 Essential Training
Restore logical database backups
- [Instructor] In the last video we created a couple of logical database backup files in our home directory. We can verify their existence by typing in ls, space, dash, one, space, tilde, slash, asterisk, dot, sql. Hit enter. Now let's use these files to restore our database. First let's log in to MariaDB's (mumbles) MySQl interactive tool. Type is mysql, space, dash, u, space, root, space, dash, p and hit enter and enter your database password. Let's get a list of databases by typing in show, space, databases, semicolon. We can see our Linux devs database, which we backed up in a previous video. Let's drop this database using the drop command. Type in drop, space, database, space, linuxdevs, semicolon and hit enter and we'll verify with show, space, databases, semicolon. Now that we see it's gone let's exit and restore the Linux devs database from our backup. Type in exit. Now type in clear to clear your screen. Now we use a MySQL command in a noninteractive way to restore the…
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
-
-
-
-
-
-
-
-