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

1. 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. 2. 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. Submit the backup script.