Solved

select into outfile permission denied on windows 8

Posted on 2014-01-08
1
2,610 Views
Last Modified: 2014-01-08
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
0
Comment
Question by:andieje
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 39766086
The default NTFS permissions on Windows is more secure in newer versions, try sending the output file to C:\Temp\output.txt or your documents folder (i.e., C:\users\%username%\documents).
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question