LOAD DATA INFILE does not import to mysql database

Question

I have mysql table called 'master'

CREATE TABLE `master` ( `id` int(7) NOT NULL AUTO_INCREMENT, `destination` varchar(30) NOT NULL, `bay` varchar(5) DEFAULT NULL, `shipInvoiceNumber` varchar(20) NOT NULL, `invoiceNumber` varchar(20) DEFAULT NULL, `start` varchar(20) NOT NULL, `end` varchar(20) NOT NULL, KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=100113 DEFAULT CHARSET=latin1;

i have write a code using LOAD DATA INFILE.

mysql_query("LOAD DATA INFILE 'master.csv' INTO TABLE master fields terminated by ',' (destination,bay,shipInvoiceNumber,invoiceNumber,start,end);");

my 'master.csv' file

KANDY,Bay1,2011/331,5618,60842,60855
KANDY,Bay1,2011/331,5618,62493,62493

but it didnt import data in to database table.

any issue?

What happened instead? Did you get error messages? Where did you run the query from? — Pekka
– Pekka, Commented Aug 21, 2011 at 7:18

Andrej · Accepted Answer · 2011-08-21 09:18:51Z

It can be two causes without additional info about error:

Mysql is remote server and you try to load file from remote server. So you use LOAD DATA LOCAL INFILE. See section with LOCAL description in http://dev.mysql.com/doc/refman/5.1/en/load-data.html
You haven't got permissions to run this command

Collectives™ on Stack Overflow

LOAD DATA INFILE does not import to mysql database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related