E
E
Egorithm2016-06-22 19:32:53
linux
Egorithm, 2016-06-22 19:32:53

MySQL. How to upload data in Linux (Mint)?

I could not solve the problem with encodings in Windows, I switched to Linux, hoping that I would forget this hemorrhoid and finish the course, but no ...
Cyrillic even in UTF-8 and the bash shell managed to be saved like this:

+------------+----------------------------------------------------+------+-----+---------+-------+
| Field      | Type                                               | Null | Key | Default | Extra |
+------------+----------------------------------------------------+------+-----+---------+-------+
| id_station | smallint(2) unsigned zerofill                      | NO   | PRI | 00      |       |
| name       | varchar(30)                                        | NO   |     | NULL    |       |
| type       | enum('?????????','?????????????','??????????????') | NO   |     | NULL    |       |
+------------+----------------------------------------------------+------+-----+---------+-------+

Here is an attempt to load data into a table:
mysql> load data local infile '/home/egor/desktop/CityNetwork' into table CityNetwork
    -> fields terminated by '\t' lines terminated by '\n';

Here's an error:
ERROR 1148 (42000): The used command is not allowed with this MySQL version

Version:
mysql> select version(); 
+-------------------------+
| version()               |
+-------------------------+
| 5.5.49-0ubuntu0.14.04.1 |
+-------------------------+
1 row in set (0.02 sec)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey, 2016-06-22
@EgoRusMarch

What is the encoding of the table? right, latin1.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question