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