MySQL Sample Database Sakila-db installation

Recently looking at "high-performance MySQL" This book, found many examples above the official sample database Sakila.

Official Sample Database

Http://dev.mysql.com/doc/index-other.html

Documenation-other docs-example Databases Sample libraries and documents are put together to jump to the download interface.

Unzip the import Sakila Database

Upload files to any path

[[email protected] etc]# ll total dosage 756-rw-r--r--1 root   root   741613 July   6 17:53 sakila-db.zip

　　

Unzip the file

[Email protected] etc]# unzip Sakila-db.zip Archive:  sakila-db.zip   creating:sakila-db/  inflating: Sakila-db/sakila-data.sql    Inflating:sakila-db/sakila-schema.sql    

　　

After decompression, you can see the following files

[[email protected] sakila-db]# ll total dosage 3396-rw-r--r--1 root root 3398148 July  sakila-data.sql-rw-r--r--1 root ro OT   50019 July  sakila.mwb-rw-r--r--1 root root   23424 July  sakila-schema.sql

　　

Import SQL file

[Email protected] sakila-db]#  

Check that the imported data is successful (choose one of two detection methods)

[[email protected] sakila-db]# mysqlwelcome to the MySQL Monitor. Commands End With; or \g.your MySQL connection ID is 30659Server version:5.6.36-log Source distributioncopyright (c), Oracle and/ or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> mysql> mysql> show databases;+--------------------+| Database |+--------------------+| Information_schema | | jfedu | | MySQL | | Performance_schema | | Sakila | | Test | | Zabbix |+--------------------+7 rows in Set (0.01 sec) mysql> use sakilareading table information for Comple  tion of table and column namesyou can turn off this feature to get a quicker startup With-adatabase changedmysql> 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) mysql>

Sample Database Import complete

MySQL Sample Database Sakila-db installation