Difference between revisions of "SQWareProduction:mysql:etc:.profile confort"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
m (Updated by Expdbtools)
Line 4: Line 4:
 
Alias explanation:
 
Alias explanation:
 
<pre>
 
<pre>
  echo => 'echo -e'
+
echo => 'echo -e'
  put => "echo $lvsqw_EchoOpt '\033]0;${gvsqw_UserExec}@$gvsqw_Hostname    ${MYSQL_SID}          (expdbTools v$gvsqw_EdtVersion GPL v3)\033\\'"
+
put => "echo $lvsqw_EchoOpt '\033]0;${gvsqw_UserExec}@$gvsqw_Hostname    ${MYSQL_SID}          (dbSQWare v$gvsqw_EdtVersion GPL v3)\033\\'"
  erase => 'stty erase ^H'
+
erase => 'stty erase ^H'
  so => 'set -o emacs'
+
so => 'set -o emacs'
  h => 'history -100'
+
h => 'history -100'
  ll => 'ls -al'
+
ll => 'ls -al'
  lt => 'ls -altr'
+
lt => 'ls -altr'
  top => '/usr/local/bin/top'
+
top => '/usr/local/bin/top'
  cls => 'clear'
+
cls => 'clear'
  l => 'ls -l'
+
l => 'ls -l'
  lrt => 'ls -rtl'
+
lrt => 'ls -rtl'
  p => 'pwd'
+
p => 'pwd'
un rm 2>/dev/null
+
un rm 2>/dev/null
un cp 2>/dev/null
+
un cp 2>/dev/null
un mv 2>/dev/null
+
un mv 2>/dev/null
un ls 2>/dev/null
+
un ls 2>/dev/null
  sg => 'size=$(du -sk .|cut -f1);((size=size/1024/1024));echo "$size Go";date +"%d/%m/%Y %H:%M:%S"'
+
sg => 'size=$(du -sk .|cut -f1);((size=size/1024/1024));echo "$size Go";date +"%d/%m/%Y %H:%M:%S"'
  sm => 'size=$(du -sk .|cut -f1);((size=size/1024));echo "$size Mo";date +"%d/%m/%Y %H:%M:%S"'
+
sm => 'size=$(du -sk .|cut -f1);((size=size/1024));echo "$size Mo";date +"%d/%m/%Y %H:%M:%S"'
  dmp => 'cd $gvsqw_RootDump; ls -al';
+
dmp => 'cd $gvsqw_RootDump; ls -al';
  dbf => 'cd $gvsqw_RootDbf; ls -al';
+
dbf => 'cd $gvsqw_RootDbf; ls -al';
  bin => 'cd $gvsqw_MysBin; ls -al';
+
bin => 'cd $gvsqw_MysBin; ls -al';
  lib => 'cd $gvsqw_MysBin/../lib; ls -al';
+
lib => 'cd $gvsqw_MysBin/../lib; ls -al';
  men => 'cd $gvsqw_MysBin/../menu; ls -al';
+
men => 'cd $gvsqw_MysBin/../menu; ls -al';
  too => 'cd $gvsqw_MysBin/../tools; ls -al';
+
too => 'cd $gvsqw_MysBin/../tools; ls -al';
  etc => 'cd $gvsqw_MysBin/../etc; ls -al';
+
etc => 'cd $gvsqw_MysBin/../etc; ls -al';
  cbin => 'cd $gvsqw_MysBin/../bin_cust; ls -al';
+
cbin => 'cd $gvsqw_MysBin/../bin_cust; ls -al';
  clib => 'cd $gvsqw_MysBin/../lib_cust; ls -al';
+
clib => 'cd $gvsqw_MysBin/../lib_cust; ls -al';
  cmen => 'cd $gvsqw_MysBin/../menu_cust; ls -al';
+
cmen => 'cd $gvsqw_MysBin/../menu_cust; ls -al';
  ctoo => 'cd $gvsqw_MysBin/../tools_cust; ls -al';
+
ctoo => 'cd $gvsqw_MysBin/../tools_cust; ls -al';
  cetc => 'cd $gvsqw_MysBin/../etc_cust; ls -al';
+
cetc => 'cd $gvsqw_MysBin/../etc_cust; ls -al';
  hlp => 'cd $gvsqw_MysBin/../help; ls -al';
+
hlp => 'cd $gvsqw_MysBin/../help; ls -al';
  chlp => 'cd $gvsqw_MysBin/../help_cust; ls -al';
+
chlp => 'cd $gvsqw_MysBin/../help_cust; ls -al';
  my => 'mysql -S $gvsqw_MysqlSock -u $USER'
+
e => '. $gvsqw_MysBin/../tools/sqwmys_SetEnv.ksh'
  myps => '/usr/ucb/ps -auxwww | grep mysqld | grep $MYSQL_SID'  
+
my => 'mysql -S $gvsqw_MysqlSock -u $USER'
  memps => '/usr/ucb/ps -auxwww | grep mysql-monitor-agent | grep $MYSQL_SID'
+
myps => '/usr/ucb/ps -auxwww | grep mysqld | grep $MYSQL_SID'  
  myps => 'ps -edf | grep mysqld | grep $MYSQL_SID'  
+
memps => '/usr/ucb/ps -auxwww | grep mysql-monitor-agent | grep $MYSQL_SID'
  memps => 'ps -edf | grep mysql-monitor-agent | grep $MYSQL_SID'
+
myps => 'ps -edf | grep mysqld | grep $MYSQL_SID'  
  CFG => 'cd $MYSQL_HOME;vi -R my.cnf'
+
memps => 'ps -edf | grep mysql-monitor-agent | grep $MYSQL_SID'
  memcfg => 'cd $MEM_HOME; vi -R etc/mysql-monitor-agent.ini'
+
CFG => 'cd $MYSQL_HOME;vi -R my.cnf'
  err => 'cd $MYSQL_HOME/log; tail -100 $MYSQL_SID.error.log'
+
memcfg => 'cd $MEM_HOME; vi -R etc/mysql-monitor-agent.ini'
  memerr => 'cd $MEM_HOME; tail -100 mysql-monitor-agent.$MYSQL_SID.log'
+
err => 'cd $MYSQL_HOME/log; tail -100 $MYSQL_SID.error.log'
  mysp => 'my -e "show processlist"'
+
memerr => 'cd $MEM_HOME; tail -100 mysql-monitor-agent.$MYSQL_SID.log'
  cfg => 'cd $gvsqw_RootCfg; ls -al';
+
mysp => 'my -e "show processlist"'
  log => 'cd $gvsqw_RootAdmin/logs; ls -ltr';
+
cfg => 'cd $gvsqw_RootCfg; ls -al';
  tmp => 'cd $gvsqw_RootAdmin/tmp; ls -ltr';
+
log => 'cd $gvsqw_RootAdmin/logs; ls -ltr';
 +
tmp => 'cd $gvsqw_RootAdmin/tmp; ls -ltr';
 
</pre>
 
</pre>
 
<br>
 
<br>

Revision as of 23:39, 22 December 2010

File to put aliases $gvsqw_MysBin/../etc/.profile_confort:
Contains confort aliases of SQWareProduction for RDBMS mysql.

Alias explanation:

	 echo => 'echo -e'
 put => "echo $lvsqw_EchoOpt '\033]0;${gvsqw_UserExec}@$gvsqw_Hostname     ${MYSQL_SID}          (dbSQWare v$gvsqw_EdtVersion GPL v3)\033\\'"
 erase => 'stty erase ^H'
 so => 'set -o emacs'
 h => 'history -100'
 ll => 'ls -al'
 lt => 'ls -altr'
 top => '/usr/local/bin/top'
 cls => 'clear'
 l => 'ls -l'
 lrt => 'ls -rtl'
 p => 'pwd'
un rm 2>/dev/null
un cp 2>/dev/null
un mv 2>/dev/null
un ls 2>/dev/null
 sg => 'size=$(du -sk .|cut -f1);((size=size/1024/1024));echo "$size Go";date +"%d/%m/%Y %H:%M:%S"'
 sm => 'size=$(du -sk .|cut -f1);((size=size/1024));echo "$size Mo";date +"%d/%m/%Y %H:%M:%S"'
 dmp => 'cd $gvsqw_RootDump; ls -al';
 dbf => 'cd $gvsqw_RootDbf; ls -al';
 bin => 'cd $gvsqw_MysBin; ls -al';
 lib => 'cd $gvsqw_MysBin/../lib; ls -al';
 men => 'cd $gvsqw_MysBin/../menu; ls -al';
 too => 'cd $gvsqw_MysBin/../tools; ls -al';
 etc => 'cd $gvsqw_MysBin/../etc; ls -al';
 cbin => 'cd $gvsqw_MysBin/../bin_cust; ls -al';
 clib => 'cd $gvsqw_MysBin/../lib_cust; ls -al';
 cmen => 'cd $gvsqw_MysBin/../menu_cust; ls -al';
 ctoo => 'cd $gvsqw_MysBin/../tools_cust; ls -al';
 cetc => 'cd $gvsqw_MysBin/../etc_cust; ls -al';
 hlp => 'cd $gvsqw_MysBin/../help; ls -al';
 chlp => 'cd $gvsqw_MysBin/../help_cust; ls -al';
 e => '. $gvsqw_MysBin/../tools/sqwmys_SetEnv.ksh'
 my => 'mysql -S $gvsqw_MysqlSock -u $USER'
	 myps => '/usr/ucb/ps -auxwww | grep mysqld | grep $MYSQL_SID' 
	 memps => '/usr/ucb/ps -auxwww | grep mysql-monitor-agent | grep $MYSQL_SID'
	 myps => 'ps -edf | grep mysqld | grep $MYSQL_SID' 
	 memps => 'ps -edf | grep mysql-monitor-agent | grep $MYSQL_SID'
 CFG => 'cd $MYSQL_HOME;vi -R my.cnf'
 memcfg => 'cd $MEM_HOME; vi -R etc/mysql-monitor-agent.ini'
 err => 'cd $MYSQL_HOME/log; tail -100 $MYSQL_SID.error.log'
 memerr => 'cd $MEM_HOME; tail -100 mysql-monitor-agent.$MYSQL_SID.log'
 mysp => 'my -e "show processlist"'
 cfg => 'cd $gvsqw_RootCfg; ls -al';
 log => 'cd $gvsqw_RootAdmin/logs; ls -ltr';
 tmp => 'cd $gvsqw_RootAdmin/tmp; ls -ltr';