is there a way or possibly a command line tool for querying a remote file and having it dump the select into a local outfile. it does exacly what i want from the server, but only to create a file on the server. and just adding local doesn't/hasn't work. and mysqldump outputs sql, which isn't what i'm looking for either.
SELECT blah, blah2, blah3 ......... INTO LOCAL OUTFILE 'blubering.txt' FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '' FROM chatter_table; -- If there are self-made purgatories, then we all have to live in them. -- Spock, "This Side of Paradise", stardate 3417.7 --------------------------------------------------------------------- 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