Access Denied to MYSQL Outfile

This is a discussion on Access Denied to MYSQL Outfile within the MySQL Database forums, part of the Database Forums category; when I use Select * into outfile "filename.txt", a file is produced that I dont have access to. ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 10-17-2007
djk
 
Posts: n/a
Default Access Denied to MYSQL Outfile

when I use
Select * into outfile "filename.txt", a file is produced that I dont
have access to.
The file is owned by administrators as shown below.

Directory of D:\download\validation

10/16/2007 03:25 PM 1,518 BUILTIN\Administrators
cost_center.csv
1 File(s) 1,518 bytes
0 Dir(s) 2,993,750,016 bytes free


How do I get MYSQL to produce a file that I can get to?

Reply With Quote
  #2 (permalink)  
Old 10-17-2007
lark
 
Posts: n/a
Default Re: Access Denied to MYSQL Outfile

== Quote from djk (daniel.katcher@gmail.com)'s article
> when I use
> Select * into outfile "filename.txt", a file is produced that I dont
> have access to.
> The file is owned by administrators as shown below.
> Directory of D:\download\validation
> 10/16/2007 03:25 PM 1,518 BUILTIN\Administrators
> cost_center.csv
> 1 File(s) 1,518 bytes
> 0 Dir(s) 2,993,750,016 bytes free
> How do I get MYSQL to produce a file that I can get to?


try the full path to the file.
--
POST BY: lark with PHP News Reader ;o)
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:10 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0