MySQL示例数据库sakila-db的安装导入

MySQL示例数据库sakila-db的安装导入

---

---

  
sakila库是一个MySQL官方提供的模拟电影出租厅信息管理系统的数据库，类似于Oracle的scott库，sakila库的下载地址为：http://downloads.mysql.com/docs/sakila-db.zip。压缩包包括3个文件：sakila-schema.sql、sakila-data.sql和sakila.mwb，分别是sakila库的表结构创建、数据灌入、sakila的MySQL Workbench数据模型（可以在MySQL工作台打开查看数据模型）。

sakila-db.zip

---

---

下载： https://dev.mysql.com/doc/index-other.html    或   http://downloads.mysql.com/docs/sakila-db.zip

[root@LHRDB tmp]# 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@LHRDB tmp]# cd sakila-db [root@LHRDB sakila-db]# ll total 3396 -rw-r--r-- 1 root root 3398148 Jul 21  2016 sakila-data.sql -rw-r--r-- 1 root root   50019 Jul 21  2016 sakila.mwb -rw-r--r-- 1 root root   23424 Jul 21  2016 sakila-schema.sql [root@LHRDB sakila-db]# mysql < sakila-schema.sql [root@LHRDB sakila-db]# mysql < sakila-data.sql [root@LHRDB sakila-db]# mysql  Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.19 MySQL Community Server (GPL) 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> show databases; +--------------------+ | Database           | +----------