CODEWITHSUNDEEP
phpmysql
Harinder
Harinder

Reputation: 1257

LOAD DATA LOCAL INFILE php mysql

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)

Upvotes: 5

Views: 3120

Answers (2)

Sam
Sam

Reputation: 41

use local infile like below:

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

Upvotes: -1

asdawrqtgf
asdawrqtgf

Reputation: 640

'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.

Upvotes: 4

Related Questions