General Information

Backing up and restoring a database.

The following virtual machines will be used:

• server2.example.com (192.168.1.151) → Database installed here

Previous Sections Completed

• Install and Configure MariaDB
• Create a Simple Database Schema
• Perform Simple SQL Queries Against a Database

Documentation

man mysqldump

Backup 1 specific database: Run the MySQL Dump utility to backup tables within a database

mysqldump -u root -p emails > /backup/emails_backup.sql

• Builds SQL commands that will create the tables from scratch

Backup multiple databases

mysqldump -u root -p --databases emails mysql > /backup/emails_mysql_backup.sql

• –databases → flag to backup multiple databases at once

Backup all databases

mysqldump -u root -p --all-databases > /backup/all_dbs.sql

Restore 1 specific database's tables: Re-create database if it does not exist, then restore the tables

mysql -u root -p
MariaDB [(none)]> CREATE DATABASE emails;
MariaDB [(none)]> quit
mysql -u root -p emails < /backup/emails_backup.sql