Your issue is more to do with what ls gets for agrument when is shellscript:
for your script mls will because of $1 get ONLY 1 argument for that is what $1 stands for...
how to run a script using cron job and send the output as attachment via e-mail using unix. please help me.
how my cron job entry should be?
As of now my cron job entry is to run the script at specific time,
15 03 * * * /path/sample.sh | mail -s "Logs" email_id
In the above entry, what... (8 Replies)
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
If I run 'who -u' interactively or from a script invoked through bash in a tty on my Ubuntu 12LTS box I get an output like this:
testuser pts/0 Dec 9 02:32 . 2163 (host.xx.yy)
running the same through cron I get:
testuser pts/0 2012-12-09 02:32 00:05 2163... (2 Replies)
Hi Expert,
I have a .sh script in my home/new_dir/script.sh
This script creates number of output files at home/new_dir/email, home/new_dir/logs dir.
I am running this script using crontab (owner root).
Now this output files are getting created with
rw-r----- 1 root root
So if i... (2 Replies)
Hi All,
I have a script which checks the status of HP Smart Array & then emails me the output.
The script run fine when executed manually but I receive no output when configured in a cron job.
The script is below:
hpacucli ctrl slot=3 show config | mail -s "ARRAY STATUS-`date`"... (6 Replies)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Hi Guys,
I am very new to shell script and I need your help here to write a script. Actually, I have a script abc.sh which don't get terminated itself. So I need to design a script to run this script, save the output to a file, search for a given string in the output and if it exists send those... (11 Replies)
Hello Team .
I am working a health check script ( bash) to run on linux server ( RedHat) and requirements are
1. The o/p of script need to be send to two diff files . I am testing with tee command . But I am not successful yet , any recommendations if that is the right approach ?
2. The same... (2 Replies)
Experts,
I am writing a script and able to write only small piece of code and not able to collect logic to complete this task.
In input file have to look for name like like this (BGL_HSR_901_1AG_A_CR9KTR10) before sh iss neors. Record this (BGL_HSR_901_1AG_A_CR9KTR10) in csv file
Now have to... (0 Replies)
Discussion started by: as7951
0 Replies
LEARN ABOUT REDHAT
mysqlaccess
MYSQLACCESS(1) General Commands Manual MYSQLACCESS(1)NAME
mysqlaccess
- Create new users to mysql.
USAGE
mysqlaccess [host [user [db]]] OPTIONS
SYNOPSIS
mysqlaccess [-?|--help] [-v|--version] [-p|--password=#] [-h|--host=#] [-d|--db=#] [-U|--superuser=#] [-P|--spassword=#] [-H|--rhost=#]
[--old_server] [-b|--brief] [-t|--table] [--relnotes] [--plan] [--howto] [--debug=N] [--copy] [--preview] [--commit] [--rollback]
DESCRIPTION
-?|--help
display this helpscreen and exit
-v|--version
print information on the program `mysqlaccess'
-u|--user=#
username for logging in to the db
-p|--password=#
validate password for user
-h|--host=#
name or IP-number of the host
-d|--db=#
name of the database
-U|--superuser=#
connect as superuser
-P|--spassword=#
password for superuser
-H|--rhost=#
remote MySQL-server to connect to
--old_server
connect to old MySQL-server (before v3.21) which does not yet know how to handle full where clauses.
-b|--brief
single-line tabular report
-t|--table
report in table-format
--relnotes
print release-notes
--plan print suggestions/ideas for future releases
--howto
some examples of how to run `mysqlaccess'
--debug=N
enter debuglevel N (0..3)
--copy reload temporary grant-tables from original ones
--preview
show differences in privileges after making changes in (temporary) grant-tables
--commit
copy grant-rules from temporary tables to grant-tables (!don't forget to do an mysqladmin reload)
--rollback
undo the last changes to the grant-tables.
NOTE
+ At least the user and the db must be given (even with wildcards)
+ If no host is given, `localhost' is assumed
+ Wilcards (*,?,%,_) are allowed for host, user and db, but be sure
to escape them from your shell!! (ie type * or '*')
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with
no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mer-
curmedia.com)
19 December 2000 MYSQLACCESS(1)