Differences

This shows you the differences between two versions of the page.

--- linux_wiki:backup_and_restore_a_database [2016/09/11 14:51]
billdozor created
+++ linux_wiki:backup_and_restore_a_database [2019/05/25 23:50] (current)
@@ Line 4: / Line 4: @@
 Backing up and restoring a database.
+----
+====== Lab Setup ======
+The following virtual machines will be used:
+  * server2.example.com (192.168.1.151) -> Database here
+**Previous Sections Completed**
+  * [[linux_wiki:install_and_configure_mariadb|Install and Configure MariaDB]]
+  * [[linux_wiki:create_a_simple_database_schema|Create a Simple Database Schema]]
+  * [[linux_wiki:perform_simple_sql_queries_against_a_database|Perform Simple SQL Queries Against a Database]]
 ----
@@ Line 9: / Line 21: @@
 ====== Backup ======
+**Documentation**
+<code bash>
+man mysqldump
+</code>
+\\
 Backup 1 specific database: Run the MySQL Dump utility to backup tables within a database
 <code bash>
@@ Line 32: / Line 50: @@
 ====== Restore ======
+Restore 1 specific database's tables: Re-create database if it does not exist, then restore the tables
+<code bash>
+mysql -u root -p
+MariaDB [(none)]> CREATE DATABASE emails;
+MariaDB [(none)]> quit
+mysql -u root -p emails < /backup/emails_backup.sql
+</code>
 ----