LOAD DATA LOCAL INFILE php mysql

Question

I am getting error

#7890 - Can't find file 'C:UsersAdminDesktopBL postcodes.csv.zip'.

here is the script

LOAD DATA LOCAL INFILE 'C:\Users\Admin\Desktop\BL postcodes.csv.zip' 
IGNORE INTO TABLE uk_pc 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(Postcode, Latitude, Longitude, Easting, Northing, GridRef, County, District, Ward, DistrictCode, WardCode, Country, CountyCode)

i have tried to change folders and change permission also but same error ... (working on localhost server)

'C:UsersAdminDesktopBL postcodes.csv.zip' path has to be wrong cuz it doesn't have traling slashes. try: INFILE 'C:\\Users\\Admin\\Desktop\\BL postcodes.csv.zip' — asdawrqtgf
– asdawrqtgf, Commented Dec 20, 2012 at 20:10
@Disa Thx it worked but getting another error now data is my database get in wrong format some thing like this ** §@¼eSìï ®·ÔÙÇT Š!žfÈ3tx}ºz¹àì6¿uÏÍ¿ÑæË...** where am i getting wrong now :( — Harinder
– Harinder, Commented Dec 20, 2012 at 20:17
I'm pretty sure you need a regular plain-text file and compression is not supported. — tadman
– tadman, Commented Dec 20, 2012 at 20:20
@Disa Yaa great it worked ;) thx ... can u make it as ans so i can accept it and close my question .:) — Harinder
– Harinder, Commented Dec 20, 2012 at 20:21

nbanic · Accepted Answer · 2014-04-14 14:48:31Z

4

'C:UsersAdminDesktopBL postcodes.csv.zip' path has to be wrong because it doesn't have traling slashes. try: INFILE 'C:\\Users\\Admin\\Desktop\\BL postcodes.csv.zip'

And try with unpacked file.

edited Apr 14, 2014 at 14:48

nbanic

1,2801 gold badge9 silver badges12 bronze badges

answered Dec 20, 2012 at 20:22

asdawrqtgf

64013 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sam · Accepted Answer · 2015-06-25 09:44:29Z

-1

use local infile like below:

load data local infile 'C:\Users\Admin\Desktop\' into table user

answered Jun 25, 2015 at 9:44

Sam

416 bronze badges

Collectives™ on Stack Overflow

LOAD DATA LOCAL INFILE php mysql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related