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
