MYSQL Import Datagram error

start importing MYSQL Import data appears The MySQL server is running with the-- secure-file-priv option

looked up the problem of the import and export path directory of Mysql, and changed the secure-file- value in the my.ini file to

. 
secure-file-priv=""

now the error in performing SQL import is as follows: 

mysql> load data infile "E:\sql\film_test.txt" into table film_test2;

ERROR 29 (HY000): File "E:\sqlfilm_test.txt" not found (OS errno 2 - No such file or directory)

the file path is correct, how can you report an error and cannot find

Mysql
Apr.14,2021

what is your version of MySQL, and did you compile it yourself?
is a little impressed by this parameter, which is described in MySQL in the official description. The default setting is NULL, which suppresses data import and export. There are also non-NULL, values that are set to DINSTALL_SECURE_FILE_PRIVDIR=/usr/local/mysql/mysql-files , including null values, but null values can be problematic:

A non-NULL value is considered insecure if it is empty, or the value is the data directory or a subdirectory of it, or a directory that is accessible by all users. If secure_file_priv is set to a nonexistent path, the server writes an error message to the error log and exits.

roughly this means that it is best to point to a real directory that can be accessed by system users. I remember that the example written in the instruction manual is new in the / usr/local/mysql directory.

there is a software called Navicat

Previous: May I ask canvas if you draw a turning movement?

Next: When you use flex box to make a horizontal card scroll bar, the box-shadow shadow of the last card is trimmed.

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b37253-2c063.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b37253-2c063.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?