Re: select into dumpfile

[Carl Troein <carl@xxxxxxxxxx>]

CRAUSAZ Yann writes:

> For a project in my school, I have to store files into a MySql DB, and to
> retrieve them to special locations. My problem is that I'm unable to write
> the files anywhere else than in (something like) /var/lib/mysql (the
> standard location of MySql). The error message is "cannot create/write a
> file", even if I'm logged as root !!! 

Who you are logged in as is completely irrelevant, as the OUTFILE/
DUMPFILE file access is done entirely by mysqld and not by the client.
Assuming that you have set up the FILE privilege in a safe and
sensible way, you just need to consider the file system permissions.
Make sure whatever file you try to dump to is really writable by
whatever user mysqld runs as.

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 carl@xxxxxxxxxx | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92319@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php