03-22-2005
You can try as,
date >> /tmp/sqllogfile
mysql -q -h <host> -p <passwd> <<EOF
use <database>;
select COUNT(*) from <table>;
\q;
EOF >> /tmp/sqllogfile
echo >> /tmp/sqllogfile
It will log every information with row count in /tmp/sqllogfile file. Automate this script with cron.
HTH.
EOF
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
i am using SuonOS and ksh.
i need to add data into a file(s.txt) using a shell script. i have to pass 3 parameters and these 3 paramaters should add into the file at end of the file.
File s.txt is look like,
---------------------------------
column1|column2|column3
... (1 Reply)
Discussion started by: syamkp
1 Replies
2. Shell Programming and Scripting
Hi everyone,
the problem is quite simple, yet I can't find an easy solution using awk.
I need to search for a string in $3, then if I find this string, copy the line,modify $3, and copy the next 9 lines to the same file.
My problem is in the copying of the lines... Finding and modifying... (5 Replies)
Discussion started by: Teroc
5 Replies
3. Shell Programming and Scripting
Hi,
I have a text file which is following format -
COL VAL
ABC 1
ABC 2
ABC 3
ABC 4
ABC 5
My requirement is to search for a particular value (provided by user) in the file and comment the previous entries including that as well.
E.g. If I search for number 3, then the output... (6 Replies)
Discussion started by: bhupinder08
6 Replies
4. Shell Programming and Scripting
Hi,
I want a script shell to automate modifying httpd.conf file for
several instances of apache, save httpd.file before changing it, after
modifying it and then restart apache.
- Replace ServerRoot "xxxx" by ServerRoot "yyyy" of all directories :
"... (4 Replies)
Discussion started by: bras39
4 Replies
5. Shell Programming and Scripting
I have a shell script running to load some data from a text file to database. Text file contains some non-ASCII characters like ü. How can i convert these characters to UTF-8 codes before loading to DB. (5 Replies)
Discussion started by: vel4ever
5 Replies
6. Shell Programming and Scripting
Plz help me
To modify "cal " command to display calenders of the specified months.
$ cal jan mar nov (0 Replies)
Discussion started by: shivasaini
0 Replies
7. Shell Programming and Scripting
Plz help me
To modify "cal " command to display calenders of the specified months.
$ cal jan....oct (0 Replies)
Discussion started by: shivasaini
0 Replies
8. Shell Programming and Scripting
Plz help me
a) To display on the screen the sorted output of "who" along with the total no. of users.
b) the same output (except the no. of users) should be in file FILE1. (2 Replies)
Discussion started by: shivasaini
2 Replies
9. Shell Programming and Scripting
Hi All
Need some help with a unix shell script. I have a XML file as shown below:
<Root>
<Service>
<endPoint type="SOAP" protocol="http">
<provider>ABCD</provider>
<urlRewrite>/service/xyz/getAccountDetails</urlRewrite>
<timeout>30</timeout>
</endPoint>
</Service>
<Service>
<endPoint... (3 Replies)
Discussion started by: abhilwa
3 Replies
10. UNIX for Dummies Questions & Answers
HI Guys,
Input :- P081 wr1 12p0d5: 22.8
P081 wr1 12p2d18: 23.1
P149 wr1 1pxcud6/port_0_dev_7: 20.4
P149 wr1 1pxcud4/port_1_dev_10: 22.4
OutputP081 wr1 120 22.8
P081 wr1 122 23.1
P149 wr1 10 20.4
P149 wr1 11 22.4
In in First two line delete p and after d untill :
In Last two line... (4 Replies)
Discussion started by: pareshkp
4 Replies
i-ls(1) General Commands Manual i-ls(1)
NAME
i-ls - display file stat and checksum information for files
SYNOPSIS
i-ls [-s] filename
i-ls [-s] dirname
Specify a filename for i-ls to examine, or specify a directory with dirname to examine all the files in the directory.
-s
Do not show/calculate checksums for all regular files.
DESCRIPTION
The integrit system detects intrusion by detecting when trusted files have been altered.
integrit records information about files in a database. i-ls allows the user to see that information for live files.
The output syntax is the same as that of integrit.
EXAMPLES
i-ls /tmp/foo.txt
shows file stat attributes for the file, "/tmp/foo.txt".
i-ls /tmp
shows file stat attributes for all files in the directory, "/tmp".
i-ls -s /tmp
shows file stat attributes for all files in the directory, "/tmp", also including also checksums for all regular files.
AUTHOR
Ed L Cashin <ecashin@users.sourceforge.net>
See the integrit web site for up to date releases and information at
http://integrit.sourceforge.net/
SEE ALSO
Integrit File Verification System Manual (info), lstat(2)
Version 4.1 Jul 27, 2001 i-ls(1)