MySQL sample database installation process Sakila sharing

Typically, for a brand new MySQL server, there is no data for us to test and use. For this, MySQL provides us with a sample database on which we can perform basic operations, stress tests, and so on. This article describes installing the sakila database. The database needs to be installed above version 5.0 of MySQL. Here is its description.

1. Download the seed database

Download location: http: / / dev mysql. com doc/index - other. html

2. Install the seed database sakila

[root@localhost ~]# unzip sakila-db.zip

Archive:  sakila-db.zip

   creating: sakila-db/

  inflating: sakila-db/sakila-schema.sql  

  inflating: sakila-db/sakila.mwb    

  inflating: sakila-db/sakila-data.sql

The sakila-schema.sql file contains all the CREATE statements required to create the structure of the Sakila database including tables, views, stored procedures, and triggers.

 

The sakila-data.sql file contains the INSERT statements required to populate the structure created by the sakila-schema.sql file, along with definitions for triggers that must be created after the initial data load.
The sakila.mwb file is a MySQL Workbench data model that you can open within MySQL Workbench to examine the database structure. For more information, see MySQL Workbench.

[root@localhost ~]# ls

anaconda-ks.cfg  Desktop  install.log  install.log.syslog  sakila-db  sakila-db.zip

[root@localhost ~]# cd sakila-db

[root@localhost sakila-db]# ls

sakila-data.sql  sakila.mwb  sakila-schema.sql

[root@localhost sakila-db]# mysql -uroot -p <sakila-schema.sql

Enter password:

[root@localhost sakila-db]# mysql -uroot -p <sakila-data.sql

Enter password:

3. Verify the installation results

[root@localhost sakila-db]# mysql

root@localhost[(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| sakila             |

| scottdb            |

| tempdb             |

| test               |

+--------------------+

7 rows in set (0.01 sec)

root@localhost[(none)]> use sakila

Database changed

root@localhost[sakila]> show tables;

+----------------------------+

| Tables_in_sakila           |

+----------------------------+

| actor                      |

| actor_info                 |

| address                    |

| category                   |

| city                       |

| country                    |

| customer                   |

| customer_list              |

| film                       |

| film_actor                 |

| film_category              |

| film_list                  |

| film_text                  |

| inventory                  |

| language                   |

| nicer_but_slower_film_list |

| payment                    |

| rental                     |

| sales_by_film_category     |

| sales_by_store             |

| staff                      |

| staff_list                 |

| store                      |

+----------------------------+

23 rows in set (0.00 sec)

root@localhost[sakila]> select count(*) from customer;

+----------+

| count(*) |

+----------+

|      599 |

+----------+

1 row in set (0.01 sec)