Avelino F writes:

> I managed to set the file permission and managed to send the output to the 
> mysql database directory used. Do you know if there is a way to make mysql 
> write to a remote directory?

As in on any machine in the world? No. As in on the client machine?
Not really, since there's no equivalent of LOAD LOCAL DATA INFILE.
What you can do is either use the mysql command line client and >
to a file, or just loop over the result and save it in whatever
format you wish in your favourite language.

> Is there a global or local configuration that 
> can be specified where mysql will write to?

It will write where you tell it to, if that location fulfils the
criteria listed in the manual. I think mysql chdir()s to the
data directory, but I wouldn't rely on it. Entering the full
path isn't all that work anyway.

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to