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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
File to put aliases $gvsqw_MysBin/../etc/.profile_confort:<br>
 
File to put aliases $gvsqw_MysBin/../etc/.profile_confort:<br>
Contains confort aliases of SQWareProduction for RDBMS mysql.<br>
+
Contains confort aliases of SQWareProduction for mysql.<br>
 
<br>
 
<br>
 
Alias explanation:
 
Alias explanation:
 
<pre>
 
<pre>
 +
xtra => 'cd $gvsqw_RootXtraBackup; ls -al';
 
  dmp => 'cd $gvsqw_RootDump; ls -al';
 
  dmp => 'cd $gvsqw_RootDump; ls -al';
 
  dbf => 'cd $gvsqw_RootDbf; ls -al';
 
  dbf => 'cd $gvsqw_RootDbf; ls -al';
Line 12: Line 13:
 
  memerr => 'cd $MEM_HOME; tail -100 mysql-monitor-agent.$MYSQL_SID.log'
 
  memerr => 'cd $MEM_HOME; tail -100 mysql-monitor-agent.$MYSQL_SID.log'
 
  mysp => 'my -e "show processlist"'
 
  mysp => 'my -e "show processlist"'
  mysd => 'echo "# Liste des bases sur $MYSQL_SID" ; my -s -N -e "show databases";'
+
  mysd => 'echo $gvsqw_EchoOpt "# Liste des bases sur $MYSQL_SID" ; my -s -N -e "show databases";'
 
  cdm => 'cd $MYSQL_HOME'
 
  cdm => 'cd $MYSQL_HOME'
 
</pre>
 
</pre>
 
<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'