安装MySQL样本数据库Sakila，mysql样本sakila
通常情况下对于一个全新的MySQL服务器，没有任何数据供我们测试和使用。对此，MySQL为我们提供了一些样本数据库，我们可以基于这些数据库作基本的操作以及压力测试等等。本文描述的是安装sakila数据库。该数据库需要安装在MySQL 5.0以上的版本。以下是其描述。
1、下载种子数据库
下载位置：http://dev.mysql.com/doc/index-other.html
2、安装种子数据库sakila
[root@localhost ~]# unzip sakila-db.zip
Archive: sakila-db.zip
creating: sakila-db/
inflating: sakila-db/sakila-schema.sql
inflating: sakila-db/sakila.mwb
inflating: sakila-db/sakila-data.sql
The sakila-schema.sql file contains all the CREATE statements required to create the structure of the Sakila database including tables, views, stored procedures, and triggers.
The sakila-data.sql file contains the INSERT statements required to populate the structure created by 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 MySQL Workbench.
[root@localhost ~]# ls
anaconda-ks.cfg Desktop install.log install.log.syslog sakila-db sakila-db.zip
[root@localhost ~]# cd sakila-db
[root@localhost sakila-db]# ls
sakila-data.sql sakila.mwb sakila-schema.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:
3、验证安装结果
[root@localhost sakila-db]# mysql
root@localhost[(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| scottdb |
| tempdb |
| test |
+--------------------+
7 rows in set (0.01 sec)
root@localhost[(none)]> use sakila
Database changed
root@localhost[sakila]> 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)
root@localhost[sakila]> select count(*) from customer;
+----------+
| count(*) |
+----------+
| 599 |
+----------+
1 row in set (0.01 sec)
更多参考: http://dev.mysql.com/doc/sakila/en/sakila-installation.html
select id from SAKILA order by xx limit 0,1
进入MySQL目录下的bin文件夹
mysqldump -u 用户名 -p 数据库名 > 导出的文件名
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqldump -u root -p Test > test.sql
Enter password: ********
C:\Program Files\MySQL\MySQL Server 5.5\bin>dir *.sql
驱动器 C 中的卷没有标签。
卷的序列号是 406A-C32E
C:\Program Files\MySQL\MySQL Server 5.5\bin 的目录
2013-01-29 16:34 39,574 test.sql
1 个文件 39,574 字节
0 个目录 5,498,294,272 可用字节
导入
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.5.29 MySQL Community Server (GPL)
Copyright (c) 2000, 2012, 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> create database test2;
Query OK, 1 row affected (0.04 sec)
mysql> use test2
Database changed
mysql> source test.sql
......