mysql中安装样本数据库sakila过程分享

1、通常情况下对于一个全新的mysql服务器，没有任何数据供我们测试和使用。对此，mysql为我们提供了一些样本数据库，我们可以基于这些数据库作基本的操作以及压力测试等等。本文描述的是安装sakila数据库。该数据库需要安装在mysql 5.0以上的版本。以下是其描述。1、下载种子数据库下载位置：>2、安装种子数据库sakila代码如下：rootlocalhost # unzip sakila-db.ziparchive: sakila-db.zipcreating: sakila-db/inflating: sakila-db/sakila-schema.sqlinflating:

2、 sakila-db/sakila.mwbinflating: sakila-db/sakila-data.sqlthe sakila-schema.sql file contains all the create statements required to create the structure ofthe sakila database including tables, views, stored procedures, and triggers.the sakila-data.sql file contains the insert statements required to p

3、opulate the structure createdby the sakila-schema.sql file, along with definitions for triggers that must be created after the initial data load.the sakila.mwb file is a mysql workbench data model that you can open within mysql workbench to examine the database structure. for more information, see m

4、ysql workbench.rootlocalhost # lsanaconda-ks.cfg desktop install.log install.log.syslog sakila-db sakila-db.ziprootlocalhost # cd sakila-dbrootlocalhost sakila-db# lssakila-data.sql sakila.mwb sakila-schema.sqlrootlocalhost sakila-db# mysql -uroot -p <sakila-schema.sqlenter password:rootlocal

5、host sakila-db# mysql -uroot -p <sakila-data.sqlenter password:3、验证安装结果代码如下：rootlocalhost sakila-db# mysql )> show databases;+| database |+| information_schema | mysql | performance_schema | sakila | scottdb | tempdb | test |+7 rows in set (0.01 sec)> use sakiladatabase changed&

6、amp;gt; 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)