You need to have 'File' priveleges to accomplish this.
Mustafa SARI wrote:
> I have a problem between mysql and the server.
> whenever I type
> " select * from dugun into outfile '\\home\\kitapci\\jj.txt'; "
> it gives such an error.
> ERROR 2000: Access denied for user: 'prog1@localhost' (Using password: YES)
> how can I solve this problem?
> Eventhough given path for output file is true and there is a table named "dugun", it
> doesnt work.
> thank you.
> mustafa sari