mysql sakila 执行失败

1.下载

https://dev.mysql.com/doc/index-other.html

2.解压

3.将解压的文件放入某个位置,必须tmp下面

4.登录mysql 进行source处理

mysql> source /tmp/sakila-schema.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.33 sec)

Query OK, 0 rows affected (0.40 sec)

Query OK, 0 rows affected (0.28 sec)

Query OK, 0 rows affected (0.37 sec)

Query OK, 0 rows affected (0.36 sec)

Query OK, 0 rows affected (0.41 sec)

Query OK, 0 rows affected (0.38 sec)

Query OK, 0 rows affected (0.35 sec)

Query OK, 0 rows affected (0.34 sec)

Query OK, 0 rows affected (1.86 sec)

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.40 sec)

Query OK, 0 rows affected (0.34 sec)

Query OK, 0 rows affected (0.41 sec)

Query OK, 0 rows affected (0.46 sec)

Query OK, 0 rows affected (0.44 sec)

Query OK, 0 rows affected (0.40 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> source /tmp/sakila-data.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

Query OK, 200 rows affected (0.00 sec)
Records: 200  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 603 rows affected (0.15 sec)
Records: 603  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 16 rows affected (0.00 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 600 rows affected (0.12 sec)
Records: 600  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 109 rows affected (0.00 sec)
Records: 109  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 599 rows affected (0.25 sec)
Records: 599  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1000 rows affected (0.97 sec)
Records: 1000  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.07 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 5462 rows affected (0.73 sec)
Records: 5462  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1000 rows affected (0.15 sec)
Records: 1000  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 4581 rows affected (0.55 sec)
Records: 4581  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 14885 rows affected (3.28 sec)
Records: 14885  Duplicates: 0  Warnings: 0

Query OK, 1164 rows affected (0.01 sec)
Records: 1164  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.07 sec)

Query OK, 0 rows affected (0.08 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 12377 rows affected (3.43 sec)
Records: 12377  Duplicates: 0  Warnings: 0

Query OK, 3667 rows affected (0.06 sec)
Records: 3667  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.41 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 2 rows affected (0.04 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected, 1 warning (0.05 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)


通过source处理,成功的导入了数据。

posted @ 2018-05-27 23:38  TBHacker  阅读(340)  评论(0编辑  收藏  举报