[Level 2] Script for mysql.

Because I have multi MySQL environments, so I have to assign different parameter (especially the "--socket" option) in different environment,
and it make me crazy.
So I create a folder "/shell" for store my scripts and create a alias "mysql" to the script in /shell.
My sample as the following:

.bashrc:
# cat ~/.bashrc | tail -3
export MYSQL_HOME=/usr/local/mysql/5.1
export PATH=$PATH:$MYSQL_HOME/bin
alias mysql="/shell/mysql"

Script /shell/mysql:
 #!/bin/bash -vx

echo "call $0..."
sMySQLCmdList="/usr/mysql/bin/mysql /usr/local/mysql/bin/mysql"
#sMySQLCmd=""
for sItem in $sMySQLCmdList
do
  if [ -f $sItem ]
  then
    sMySQLCmd=$sItem
    break
  fi
done
if pgrep mysqld
then
  mysql_socket=`ps -ef | grep mysqld | grep -v monitor | grep socket | sed -e 's/.*--socket=//' |     cut -d' ' -f1`
 
  if [ `echo $@ | grep -c -- -h` -eq 1 ]
  then
    $sMySQLCmd $@
  elif [ ! -z $mysql_socket ]
  then
    $sMySQLCmd --socket=$mysql_socket $@
  else
    $sMySQLCmd $@
  fi
else
  echo "No Running MySQL Server, Exit mysql" && exit 1
fi  


Wish this helps.

regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 1] Rar tool for Solaris.

Sometimes we will got a rar compressed file from our friends, but there is no default tool in OpenSolaris to decompress the rar filess. We can got a Solaris Intel version from rarlab . The steps as the following: 1. down load the rar tools from rarlab. http://www.rarlab.com/rar_add.htm 2. uncompressed the source. # gunzip ./unrar-sol-intel.gz 3. move it to the location you used to. # mv /unrar-sol-intel.gz /usr/bin/unrar 4. try to decomprss # unrar x ./test.rar Wish this helps. regards, Stanley Huang
Read more

[Level 2] iif in Python

If you want to implement iif in Python, please refer to the following sample code: #!/bin/env python def iif(b): return 'It\'s True' if b else 'It\'s False' print iif(True) print iif(False) And the following sample, guess what will you get! #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result: $ ./iif.py b: Ture False The second result is "False", not "b: False". Why??? Because the prededence of string concatenation is higher than if. Therefore you need to use () to make it correct. #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps. regards, Stanley Huang
Read more