Download SAKILA sample MySQL database

Learn MySQL With Sakila and MySQL GUI tool

Obtain the example Sakila database from the MySQL website to examine a professionally designed database and use a GUI Front End for MySQL instead of the command line.

There is no doubt MySQL stands out as one of many open source relational database management systems (RDBMS) that are available on the market. It can be downloaded and installed by itself or as part of a software bundle such as LAMP or WAMP (MySQL is the M in LAMP or WAMP). Once its installed, the next question is what to do with it?

Get Sakila From the MySQL Site

An excellent method for becoming familiar with both basic SQL principles as well as differences in syntax unique to an actual database like MySQL is to download an example database. From the MySQL website, find the Example Databases section and download the Sakila database in either TGZ or Zip format. Download.

The Sakila example comes with three files. Run the sakila-schema.sql first to make the schema for the database, then sakila-data.sql to populate the database. (Be sure to add the MySQL binaries to the PATH system variables. Otherwise, it will be necessary to change directory to where mysqladmin.exe and mysql.exe are and use full path to where the extracted Sakila files are located).

To create a database from the command line type:

C:\tmp\sakila-db>mysqladmin -uroot -p create sakila

Read more at Suite101: Learn MySQL With Sakila and MySQL-Front: Review a Sample Database Using a GUI Interface http://database-programming.suite101.com/article.cfm/learn-mysql-with-sakila-and-mysql-front#ixzz0ggZ3Yjlf