can´t load TXT File into table

Anon

i´m trying with no success the following command in MySql. Get error 2 "file not find". "myfile.txt" is on my PC and "mytable" is on server host. Anyone can help?

LOAD DATA LOCAL INFILE 'c:/myfile.txt' INTO TABLE mytable FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\n'

mentalfloss

"The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. If the LOCAL keyword is specified, the file is read from the client host. If LOCAL is not specified, the file must be located on the server. (LOCAL is available in MySQL Version 3.22.6 or later.)" from MySQL Manual

I don't know if this helps.

I find this interesting, So with this you can load comma delimited files in to a table? or any other delimited value? to the proper fields? A type of Import.

Curious, is there a export command... to a delimited type file?

Anon

I have faced this problems and i guess this should work for u too..

Place ur file in bin folder. I think its in c:/mysql/bin

This will work

Mandar Kelkar

Anon

hi mandar,

when you got that problem were you using phpmyadmin or just plain PHP written scripts?
the following is my script that does not work. see if you can help me.

$localfile = "c:\cul.txt";

$dbh = mysql_connect($host, $user, $password);
if (!$dbh) {
die("Could not upload file");
}

$stmt = "LOAD DATA LOCAL INFILE $localfile INTO TABLE mytable FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\n' ";

$sth = mysql_query($stmt, $dbh);

mysql_free_result($sth);

mysql_close($dbh);

Anon

the funny is if I use PHPMYADMIN located at server host, the path to the TXT file, let´s say 'c:/mytxtfile' is automatically altered to something like '/tmp/somefunnyname'

so i decided to look into PHPMYADMIN FAQ and look what I found:

I try to insert a text file in a table, and I get:
Error MySQL said: The file '/tmp/phpkvpp60' must be in the database directory or be readable by all
Your uploaded file is saved by PHP in the "upload dir", as defined in php.ini by the variable upload_tmp_dir (usually the system default is /tmp). If this directory is not readable by all, the MySQL server (which must be running on the same machine) cannot open the file (except if running as root, which is not recommended).
The system administrator can do a "chmod 777 /tmp": then the MySQL server will accept to read it. Also, the user must have File privilege.

After reading it I may be confusing the term LOCAL. Is local suppose to refer my PC or some directory at server host?