MySQL示例数据库sakila-db的安装导入
下载： 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 | +--------------------+ | information_schema | | db_name | | db_name2 | | lhrdb | | mysql | | performance_schema | | sakila | | sys | +--------------------+ 8 rows in set (0.05 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> select count(*) from customer; +----------+ | count(*) | +----------+ | 599 | +----------+ 1 row in set (0.00 sec) |
通常情况下对于一个全新的MySQL服务器，没有任何数据供我们测试和使用。对此，MySQL为我们提供了一些样本数据库，我们可以基于这些数据库作基本的操作以及压力测试等等。本文描述的是安装sakila数据库。该数据库需要安装在MySQL 5.0以上的版本。以下是其描述。
<
<
