Mysql windows Error -13 and absolute path -
i've problem mysql on windows , load data infile "c:/mydir/filetoimport.csv"
(not using local) specifying absolute path "c:/mydir/filetoimport.csv" or "c:\mydir\filetoimport.csv" the file import not in mysql temp directory. i've have error -13 "can't stat of '/var/lib/mysql/c:/mydir/filetoimport.csv" problem that, stated in mysql documentation (mysql doc), if file path not start '/' mysql use relative path , try find file in /var/lib/mysql. if try, test, put '/' in front of file name '/c:/mydir/filetoimport.csv' mysql find trailing slash , not try search file temp directory , unfortunately path '/c:/mydir/filetoimport.csv' wrong interpreted , doesn't work. seems in windows not possible specify full path statement load data infile. has workaroud/suggestions?(no local option please). in advance
Comments
Post a Comment