Re: Dumping table contents to stdout in tab-separated value format

2010-02-21 Thread Евгений Килимчук
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 yanghates...@gmail.com Hi, I'm interested in

Dumping table contents to stdout in tab-separated value format

2010-02-20 Thread Yang Zhang
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

Re: Dumping table contents to stdout in tab-separated value format

2010-02-20 Thread Carlos Proal
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

Re: Dumping table contents to stdout in tab-separated value format

2010-02-20 Thread Jesper Wisborg Krogh
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