MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Евгений Килимчук Date:February 21 2010 9:09am
Subject:Re: Dumping table contents to stdout in tab-separated value format
View as plain text  
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 <yanghatespam@stripped>

> 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=1
>
>


-- 
Best regards,

Eugene Kilimchuk <ekilimchuk@stripped>

Thread
Dumping table contents to stdout in tab-separated value formatYang Zhang21 Feb
  • Re: Dumping table contents to stdout in tab-separated value formatCarlos Proal21 Feb
  • Re: Dumping table contents to stdout in tab-separated value formatJesper Wisborg Krogh21 Feb
  • Re: Dumping table contents to stdout in tab-separated value formatЕвгений Килимчук21 Feb