LOAD DATA INFILE In Denver, everything works fine, switched to the Open Server and began to pop up errors. At the beginning there were errors in connection with local-infile, in the config I changed it to 1 Then I changed the secure-file-priv to an empty value and now the error appears:

error 1300 invalid utf8 character string ''

Shoveled the entire Internet, and English too, who knows what the problem is, help

  • I work through CMD, request LOAD DATA INFILE 'G: /SCCM.csv' INTO TABLE vigruzka FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\ n'IGNORE 1 ROWS; - Fedor
  • In the very first links on spade comes out: percona.com/forums/questions-discussions/ ... - PinkTux
  • So you need to use the previous version of the server? - Fedor

0