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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
Fichier de positionnement d'alias $gvsqw_MysBin/../etc/.profile_confort:<br>
+
File to put aliases $gvsqw_MysBin/../etc/.profile_confort:<br>
−
  echo => 'echo -e'
+
Contains confort aliases of SQWareProduction for mysql.<br>
−
  put => "echo $lvsqw_EchoOpt '\033]0;${USER}@$gvsqw_Hostname    ${MYSQL_SID}          (dbsqware GPL v3)\033\\'"
+
<br>
−
  erase => 'stty erase ^H'
+
Alias explanation:
−
  so => 'set -o emacs'
+
<pre>
−
  h => 'history -100'
+
xtra => 'cd $gvsqw_RootXtraBackup; ls -al';
−
  ll => 'ls -al'
+
  dmp => 'cd $gvsqw_RootDump; ls -al';
−
  lt => 'ls -altr'
+
dbf => 'cd $gvsqw_RootDbf; ls -al';
−
  top => '/usr/local/bin/top'
+
my => "mysql $gvsqw_ConnectString"
−
  cls => 'clear'
+
CFG => 'cd $MYSQL_HOME;vi -R my.cnf'
−
  l => 'ls -l'
+
memcfg => 'cd $MEM_HOME; vi -R etc/mysql-monitor-agent.ini'
−
  lrt => 'ls -rtl'
+
err => 'cd $MYSQL_HOME/log; tail -100 $MYSQL_SID.error.log'
−
  p => 'pwd'
+
memerr => 'cd $MEM_HOME; tail -100 mysql-monitor-agent.$MYSQL_SID.log'
−
un  rm 2>/dev/null
+
mysp => 'my -e "show processlist"'
−
un cp 2>/dev/null
+
mysd => 'echo $gvsqw_EchoOpt "# Liste des bases sur $MYSQL_SID" ; my -s -N -e "show databases";'
−
un  mv 2>/dev/null
+
cdm => 'cd $MYSQL_HOME'
−
un  ls 2>/dev/null
+
</pre>
−
  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';
 
−
  my => 'mysql -S $gvsqw_MysqlSock -u $USER'
 
−
  myps => '/usr/ucb/ps -auxwww | grep mysqld | grep $USER'
 
−
  memps => '/usr/ucb/ps -auxwww | grep mysql-monitor-agent | grep $MYSQL_SID'
 
−
  myps => 'ps -edf | grep mysqld | grep $USER'
 
−
  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';
 
 
<br>
 
<br>

Latest revision as of 20:31, 27 September 2021

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

Alias explanation: 

 xtra => 'cd $gvsqw_RootXtraBackup; ls -al';
 dmp => 'cd $gvsqw_RootDump; ls -al';
 dbf => 'cd $gvsqw_RootDbf; ls -al';
 my => "mysql $gvsqw_ConnectString"
 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"'
 mysd => 'echo $gvsqw_EchoOpt "# Liste des bases sur $MYSQL_SID" ; my -s -N -e "show databases";'
 cdm => 'cd $MYSQL_HOME'


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mysql:etc:.profile_confort&oldid=18746"