Hello, I am new in this list, so let me explain problem: I use third party server provider, so having little access to resources (no telnet). I need backup remote data (BLOB fields included) and downlad it to client machine. To make things clear decided use INTO OUTFILE command to store data. Problem is INTO OUTFILE 'truefilename' command will ask for a true file name (no file pointer allowed). When I run this command, server doesnt allow create file, even making /tmp/truefilename. I tried fool OUTFILE by first creating temporary writable file via TMPFILE() PHP function, but this function just returns pointer instead name of file. I didnt find any PHP function to get name of file from file pointer. I don't want to write again all annoying code to save BLOB fields, but also can't use MySql facilities. How can I fool OUTFILE command? is there some output device a-la-console (con: in DOS) to make INTO OUTFILE 'con:' flow data to browser instead file? (I can catch browser data and redirect to local machine). Is there some way of telling OUTFILE to use file pointer instead file names? Thanks for any help from you. I asked this question on several groups, but no response obtained yet. Thanks very much Miguel --------------------------------------------------------------------- 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