MySQL Forums
Forum List  »  Newbie

Re: Ascii text boxes disappear when query output is redirected
Posted by: Michael Lueck
Date: August 21, 2010 05:40AM

Quote

You need a notee to close the file, and make it available for you to open.

So I started with the tmp file being deleted. I have added notee thusly.

#!/bin/bash
MYSQL='/usr/bin/mysql -u ucir_drupal --password=A0iWRmsnR7Zv --tee=/srv/www/sites/christians-in-recovery.org/tmp/drupal_404-query.tmp cir_drupal'
$MYSQL -e 'SELECT DISTINCT `message`, `location`, `referer` FROM `watchdog` WHERE `referer` LIKE "%christians-in-recovery.org%" AND `type` = "page not found" ORDER BY `location`, `referer`; notee;'

I did see on the console screen at the end of the query running:

Outfile disabled.

Which was encouraging, however...

:/srv/www/sites/orgname.org/bin$ ls -al ../tmp/drupal_404-query.tmp 
-rw-rw-r-- 1 mdlueck www-data 0 2010-08-20 22:21 ../tmp/drupal_404-query.tmp

Still a zero (0) length file...

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.