MySQL Forums
Forum List  »  Newbie

Ascii text boxes disappear when query output is redirected
Posted by: Michael Lueck
Date: August 20, 2010 11:07AM

Greetings-

I am trying to get a very simple query to execute and email its output as I would see when issuing the query at the mysql prompt. It executes including the desired ascii art table with this syntax:

./drupal_404-query.sh

However when I try to capture it and put it into an email:

./drupal_404-query.sh 2>&1 | /usr/bin/mailx -s "Test Query Email" root

The ascii art table suddenly goes missing.

What would be the correct syntax to use in order to retain the formatting as shown on the screen?

Thanks!

Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.