Hello!
If you use *nix sistem. You can use the 'tail' utilit with -f flag.
In the first terminal you use: mysqldump or 'select * into outfile'.
In the second terminal you can use: tail -f file_name.
This is help for monitoring.
2010/2/21 Yang Zhang
> Hi, I'm interested in piping out the contents
On 21/02/2010, at 2:03 PM, Yang Zhang wrote:
Hi, I'm interested in piping out the contents of a mysql table to
stdout in tab-separated value format, but:
- using 'select * into outfile' can't write to stdout.
- mysqldump --fields-... requires --tab, which requires an output
file path.
- I al
I dont know if this can help, but if you are on unix/linux you can call
cat after the dump and easily you can get the output to the stdout
ie:
$ mysqldumptempfile.txt... && cat tempfile.txt
Carlos
On 2/20/2010 9:03 PM, Yang Zhang wrote:
Hi, I'm interested in piping out the contents of a
Hi, I'm interested in piping out the contents of a mysql table to
stdout in tab-separated value format, but:
- using 'select * into outfile' can't write to stdout.
- mysqldump --fields-... requires --tab, which requires an output file path.
- I also tried mkfifo /tmp/pipe and "select * into outfil
