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处理,成功的导入了数据。