Errors setting up salika database
Posted by:
Richard D
Date: October 12, 2014 06:57AM
MYSQL: 5.6.17
I try to add data to the standard salika database, but I get a few errors.
mysql> SOURCE C:/temp/sakila-db/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.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 603 rows affected (0.01 sec)
Records: 603 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 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.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 600 rows affected (0.01 sec)
Records: 600 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 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.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 599 rows affected (0.01 sec)
Records: 599 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 1000 rows affected (0.12 sec)
Records: 1000 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 5462 rows affected (0.04 sec)
Records: 5462 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 1000 rows affected (0.01 sec)
Records: 1000 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 4581 rows affected (0.04 sec)
Records: 4581 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 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.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 14885 rows affected (0.26 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.04 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 12377 rows affected (0.26 sec)
Records: 12377 Duplicates: 0 Warnings: 0
Query OK, 3667 rows affected (0.05 sec)
Records: 3667 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
ERROR:
Unknown command '\"'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\''.
ERROR:
Unknown command '\n'.
ERROR:
Unknown command '\0'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ']>?q
ﾊﾝC産72>ﾏ丸ｿｱ盡9藤ﾔｪs}bﾊｹｹ)пｷﾝ0ILM.' at line 1
ERROR:
Unknown command '\Z'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '魴ｭ珞
ﾊ?ｼgjﾎ56a \ZrOMmZｬ>ｻ3硤-精メ-,?:&?*蕩3i:幼ｮ ﾐ' at line 1
ERROR:
Unknown command '\"'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\0'.
ERROR:
Unknown command '\0'.
ERROR:
Unknown command '\"'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '?Qｼ
┳糠\"藷?(紿 \\?1\0Cﾋ(脹P\0NP ｡?ﾀC](爻剋?T\"$ｷ' at line 1
ERROR:
Unknown command '\0'.
ERROR:
Unknown command '\"'.
ERROR:
Unknown command '\n'.
ERROR:
Unknown command '\Z'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'ｹｧ檠ﾎ
?ｿ?ｳﾞ?ｪｿ汜/~?篆 Ll侒鴉?=ﾚsbxzﾂ7掀/僴)' at line 1
ERROR:
Unknown command '\n'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CUﾟ~
訒t隠J顋ｳ( ?ﾀ3?ﾞｿ??ｽ1rｲ?(?X｡r?=ﾚ%(\nR?
COMMIT' at line 1
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.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)