mysql - LOAD DATA INFILE file not found error -


i have newbie mysql question: keep getting error 29 says file not found following syntax , cannot figure out why:

load data infile 'c:/users/rkartj2/desktop/loincsunquestv2.txt' table xiao fields terminated '\t' lines terminated '\n' ignore 1 rows; 

fyi - table xiao has been created in mysql 5.7 , loincsunquestv2.txt excel spreadsheet created on windows machine.

while have not used version 5.7 of mysql yet, error receiving same in previous versions. error 29 (hy000): file 'c:/users/rkartj2/desktop/loincsunquestv2.txt' not found

this may seem bit misleading newb since can go desktop , see lionsunquestv2.txt file there.

i see 1 of 2 possibilities here either mysql not have permissions access file current directory or not know file on local server.

you can try using load data local infile. dev.mysql

if not work, need move file location mysql has access to, such mysql data directory. in version 5.6 of stock vanilla install in directory: c:\programdata\mysql\mysql server 5.6. try moving file there. believe mysql looks @ location default, change load data infile 'c:/users/rkartj2/desktop/loincsunquestv2.txt' load data infile 'loincsunquestv2.txt'


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -