In this exercise, you will back up a database to create a backup script file. Then, you will make some changes to the database. Finally, you will restore the database from the backup script and the binary log file.

Back up a database

If it isn$$t already enabled, enable binary logging as described in chapter $17.$

Start a command prompt and use the mysqldump program to create a full backup of the My Guitar Shop database.

Start MySQL Workbench and open the backup script that was created by the mysqldump program. Make sure that this script contains all the SQL statements needed to restore the structure and data of the database. If necessary, add the CREATE DATABASE statement that creates the database and the USE statement that selects it$.$

Use MySQL Workbench to write and execute an INSERT statement that inserts one row into the Categories table of the My Guitar Shop database, and note the time on your computer that this statement is executed.

Wait until the time on your computer changes to at least the next minute. Then, use MySQL Workbench to execute a DROP TABLE statement that drops the Administrators table.