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 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 outfile > '/tmp/pipe'", but mysql complains about the file existing already. > > Is there any other quick way to do this without having to write a > client app? Thanks in advance. > -- > Yang Zhang > http://www.mit.edu/~y_z/ <http://www.mit.edu/%7Ey_z/> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=ekilimc...@gmail.com > > -- Best regards, Eugene Kilimchuk <ekilimc...@gmail.com>
