Re: Ascii text boxes disappear when query output is redirected

[Michael Lueck]

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/