Time for action – downloading and installing Sakila DB
Sakila DB can be downloaded from http://dev.mysql.com/doc/index-other.html.
After browsing to that URL, follow these steps to download and install Sakila:
- In the Example Databases section, you will find the links to download Sakila DB, as shown in the following screenshot.
- In Linux environments, choose the TGZ option: http://downloads.mysql.com/docs/sakila-db.tar.gz.
- In Windows environments, choose the Zip option: http://downloads.mysql.com/docs/sakila-db.zip.
- Once the correct file has been downloaded, we will unzip it in a temporary folder that we will call
[SAKILA_TMP]. - Then, we will execute two commands in a terminal to create the database and populate it with data.
- First, we will execute the
sakila-schema.sqlscript to create the general schema of the Sakila database, that is, the tables, views, and so on. After executing the following command, we will be asked for the root user password. This is determined by the following command...
