you can circumvent the problem by using stdout.
just drop the "INTO OUTFILE '/tmp/result.txt'".
the result should look something like that:
mysql -BAN -e "select ..." >filename
you can also pipe truh gzip to compress the file and save
a lot of space.
re,
wh
note: i found ";" is not a good se
Thank you for replying Carlos, but I'm under the impression that this
will also put the file on the server. Acutally, mysqldump --tab uses
INTO OUTFILE to generate the dump if i'm not mistaken
Carlos Eduardo Caldi wrote:
Hi
You can use on shell, connect at the client mysq -h (host or IP)
-p(
Hi
You can use on shell, connect at the client mysq -h (host or IP) -p(password)
and run the query:
SELECT a, b, c INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table
more info see the link
http://dev.mysql.com/doc/r
On Sun, May 05, 2002 at 07:42:13AM +0100, Alexander Shaw wrote:
>
> Using another machine (running windows) elsewhere on the network, is
> it possible to perform a mysqldump of the databases on the server?
> i.e. without having to go physically to the server machine and
> typing the commands at t
Paul DuBois wrote
"I can think of a couple of different ways to interpret your question.
Offhand, I'd say that you want to specify -h server_host on the mysqldump
command line, but if that's not what you mean, perhaps you can be more
specific."
Sorry probably not so well explained, I'll try agai
At 0:27 +0100 5/5/02, Alexander Shaw wrote:
>A quick query to save some shoe leather.
>
>Is it possible to perform a mysqldump from a remote windows client? Is so
>how?
I can think of a couple of different ways to interpret your question.
Offhand, I'd say that you want to specify -h server_host o
