Employees Sample Database  /  Installation

3 Installation

The Employees database is available from Employees DB on Launchpad. You can download a prepackaged archive of the data, or access the information through Bazaar.

To use the archive package, download the archive and unpack it:

shell> tar -xjf $HOME/Downloads/employees_db-full-1.0.6.tar.bz2
shell> cd employees_db/

The Employees database is compatible with several different storage engines, with the InnoDB engine enabled by default. Edit the employee.sql file and adjust the comments to choose a different storage engine:

   
   set storage_engine = InnoDB;
-- set storage_engine = MyISAM;
-- set storage_engine = Falcon;
-- set storage_engine = PBXT;
-- set storage_engine = Maria;

To import the data into your MySQL instance, load the data through the mysql command-line tool:

shell> mysql -t < employees.sql
+-----------------------------+
| INFO                        |
+-----------------------------+
| CREATING DATABASE STRUCTURE |
+-----------------------------+
+------------------------+
| INFO                   |
+------------------------+
| storage engine: InnoDB |
+------------------------+
+---------------------+
| INFO                |
+---------------------+
| LOADING departments |
+---------------------+
+-------------------+
| INFO              |
+-------------------+
| LOADING employees |
+-------------------+
+------------------+
| INFO             |
+------------------+
| LOADING dept_emp |
+------------------+
+----------------------+
| INFO                 |
+----------------------+
| LOADING dept_manager |
+----------------------+
+----------------+
| INFO           |
+----------------+
| LOADING titles |
+----------------+
+------------------+
| INFO             |
+------------------+
| LOADING salaries |
+------------------+

To test that the data you have loaded matches the expected results, run the test suite. For more information, see Section 4, “Validating the Employee Data”.