Importare TXT in DB mysql

[giancadeejay]

Buongiorno a tutti,
Volevo aggiornare il mio DB attraverso l'UPLOAD di un file.txt ma non riesco..
Ecco il mio script:

<?php

require ('config.php');




$sql = "LOAD DATA LOCAL INFILE '/dati.txt'
       INTO TABLE      MIA_TABELLA_DB
       FIELDS TERMINATED BY ','
       OPTIONALLY ENCLOSED BY '\"' 
       LINES TERMINATED BY '\n' 
       IGNORE 1 LINES;";


// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
};

$result = mysqli_query($sql, $con);

if (mysql_affected_rows() == 1) {
  $message = "The data was successfully added!";
} else {
  $message = "The user update failed: ";
  $message .= mysqli_error(); 
};

echo $message;

mysqli_close($con);
?>

Dove sbaglio?