1. Download
https://dev.mysql.com/doc/index-other.html
2. Unzip
3. Put the extracted files in a certain location, must tmp below
4. Log in to MySQL for source processing
mysql> source/tmp/sakila-schema.sqlquery 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 Change Dquery 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 r oWS 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 AF Fected (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 s EC) 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 r oWS 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 AF Fected (0.00 sec) mysql> source/tmp/sakila-data.sqlquery OK, 0 rows Affected (0.00 sec) Query OK, 0 rows affected (0.00 SEC) query OK, 0 rows Affected (0.00 sec) Database changedquery OK, 0 rows Affected (0.00 sec) Query OK, $ rows affected (0 . xx sec) records:200 duplicates:0 warnings:0query OK, 0 rows affected (0.09 sec) Query OK, 0 rows Affected (0.00 sec) Qu ery OK, 603 rows affected (0.15 sec) records:603 duplicates:0 warnings:0query OK, 0 rows affected (0.05 sec) Query OK, 0 rows affected (0.00 SEc) Query OK, affected (0.00 sec) records:16 duplicates:0 warnings:0query OK, 0 rows affected (0.06 sec) query ok , 0 rows Affected (0.00 sec) Query OK, $ rows Affected (0.12 sec) records:600 duplicates:0 warnings:0query 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:0query 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:0query 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, $ rows affected (0.97 sec) records:1000 duplicates:0 warnings:0query 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:0query OK, 0 rows affected (0.09 sec) query OK, 0 rows Affected (0.00 sec) Query OK, $ rows affected (0.15 s EC) records:1000 Duplicates:0 warnings:0query 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:0query 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:0query 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:0query OK, 1164 R oWS Affected (0.01 sec) records:1164 duplicates:0 warnings:0query OK, 0 rows affected (0.07 sec) Query OK, 0 rows Affec Ted (0.08 sec) query OK, 0 rows Affected (0.00 sec) Query OK, 12377 rows affected (3.43 sec) records:12377 duplicates:0 W Arnings:0query OK, 3667 rows affected (0.06 sec) records:3667 duplicates:0 warnings:0query 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:0query OK, 0 rows affected, 1 warnin G (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) Qu ery OK, 2 rows Affected (0.00 sec) Records:2 duplicates:0 warnings:0query OK, 0 rows affected (0.05 sec) Query OK, 0 ro WS Affected (0.00 sec) Query OK, 0 rows Affected (0.00 sec) Query OK, 0 rows Affected (0.00 sec)
The data was successfully imported through source processing.
MySQL Sakila execution failed