Table of Contents

1. Challenge

   Create a Partial Backup of the prod Database That Only Includes the products Table

   Run following command as cloud_user to create a backup of just the products table in the prod database:

   # mysqldump -u root -p prod products > prod_products.sql
   

2. Challenge

   Create Full Backups of the dev and test Databases

   Run following command to create backups of the dev and test databases:

   # mysqldump -u root -p --databases dev test > dev_test.sql
   

3. Challenge

   Create a Complete Backup of All the Databases on the MySQL Server

   Use the following command to create a full backup of all the databases on the MySQL server:

   # mysqldump -u root -p --all-databases > full_backup.sql
   

4. Challenge

   Create Delimited-Text Dump Files of the prod Database in the `/var/lib/mysql-files` Directory

   Run the following command to create delimited-text dump files of the prod database in /var/lib/mysql-files (the use of sudo does not require a password in this lab, so the prompt is for the MySQL root user, using the password Linux4me!:

   # sudo mysqldump -u root -p --tab=/var/lib/mysql-files/ prod
   

5. Challenge

   Perform a Full Restore of the Databases on the MySQL Server by Reloading the msyql_dump.sql Dump File Located in the `/home/cloud_user` Directory

   To perform a full restore of the MySQL server, run the following command from the /home/cloud_user directory:

   # mysql -u root -p < mysql_dump.sql