c 连接mysql.mwb_MySQL 示例数据库sakila-db的安装

最近在看 “高性能MySql”这本神书,发现上面很多例子采用的官方示例数据库sakila。

官方示例数据库

下载地址

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

Documenation - Other Docs - Example Databases 示例库和文档放到了一起  跳转到下载界面。

解压导入sakila数据库

上传文件到任意路径下

[root@localhost etc]# ll

总用量 756

-rw-r--r-- 1 root root 741613 7月 6 17:53 sakila-db.zip

解压文件

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

Archive: sakila-db.zip

creating: sakila-db/

inflating: sakila-db/sakila-data.sql

inflating: sakila-db/sakila-schema.sql

inflating: sakila-db/sakila.mwb

解压后，可以看见有如下文件

[root@localhost sakila-db]# ll

总用量 3396

-rw-r--r-- 1 root root 3398148 7月 21 2016 sakila-data.sql

-rw-r--r-- 1 root root 50019 7月 21 2016 sakila.mwb

-rw-r--r-- 1 root root 23424 7月 21 2016 sakila-schema.sql

导入sql文件

[root@localhost sakila-db]# mysql -uroot -p

Enter password:

[root@localhost sakila-db]# mysql -uroot -p

Enter password:

[root@localhost sakila-db]#

检查导入的数据是否成功(两种检测方法任选一种就可以)

[root@localhost sakila-db]# mysql

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 30659

Server version: 5.6.36-log Source distribution

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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 sakila

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> 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>

示例数据库导入完成