首页 > 代码库 > MySQL 示例数据库sakila-db的安装
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 <sakila-schema.sql Enter password: [root@localhost sakila-db]# mysql -uroot -p <sakila-data.sql 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>
示例数据库导入完成
MySQL 示例数据库sakila-db的安装
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。