andieje
asked on
select into outfile permission denied on windows 8
Hello
I am trying to run a select into outfile command from mysql 5.6 command line on windows 8 and I get a permission denied error. I have run the command prompt as administrator.
I have tried writing the output file as:
c:\outout.txt
c:\\output.txt
c:/output.txt
This is the error i get
ERROR 1 (HY000): Can't create/write to file 'C:\output.txt' (Errcode: 13 - Permi
ssion denied)
This is a cut down version of the statement
mysql> select * from testdb.web_vehicles into outfile 'C:\\output.TXT';
ERROR 1 (HY000): Can't create/write to file 'C:\output.TXT' (Errcode: 13 - Permi
ssion denied)
thanks a lot
I am trying to run a select into outfile command from mysql 5.6 command line on windows 8 and I get a permission denied error. I have run the command prompt as administrator.
I have tried writing the output file as:
c:\outout.txt
c:\\output.txt
c:/output.txt
This is the error i get
ERROR 1 (HY000): Can't create/write to file 'C:\output.txt' (Errcode: 13 - Permi
ssion denied)
This is a cut down version of the statement
mysql> select * from testdb.web_vehicles into outfile 'C:\\output.TXT';
ERROR 1 (HY000): Can't create/write to file 'C:\output.TXT' (Errcode: 13 - Permi
ssion denied)
thanks a lot
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.