Difference between revisions of "SQWareProduction:mysql:etc:.profile confort"
m (Updated by Expdbtools) |
m (Updated by Expdbtools) |
||
| Line 1: | Line 1: | ||
| − | + | File to put aliases $gvsqw_MysBin/../etc/.profile_confort:<br> | |
| + | Contains confort aliases of SQWareProduction for RDBMS mysql.<br> | ||
| + | <br> | ||
| + | Alias explanation: | ||
| + | <pre> | ||
echo => 'echo -e' | echo => 'echo -e' | ||
| − | put => "echo $lvsqw_EchoOpt '\033]0;${ | + | put => "echo $lvsqw_EchoOpt '\033]0;${gvsqw_UserExec}@$gvsqw_Hostname ${MYSQL_SID} (expdbTools v$gvsqw_EdtVersion GPL v3)\033\\'" |
erase => 'stty erase ^H' | erase => 'stty erase ^H' | ||
so => 'set -o emacs' | so => 'set -o emacs' | ||
| Line 30: | Line 34: | ||
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'; | ||
| + | chlp => 'cd $gvsqw_MysBin/../help_cust; ls -al'; | ||
my => 'mysql -S $gvsqw_MysqlSock -u $USER' | my => 'mysql -S $gvsqw_MysqlSock -u $USER' | ||
| − | myps => '/usr/ucb/ps -auxwww | grep mysqld | grep $ | + | myps => '/usr/ucb/ps -auxwww | grep mysqld | grep $MYSQL_SID' |
memps => '/usr/ucb/ps -auxwww | grep mysql-monitor-agent | grep $MYSQL_SID' | memps => '/usr/ucb/ps -auxwww | grep mysql-monitor-agent | grep $MYSQL_SID' | ||
| − | myps => 'ps -edf | grep mysqld | grep $ | + | myps => 'ps -edf | grep mysqld | grep $MYSQL_SID' |
memps => 'ps -edf | grep mysql-monitor-agent | grep $MYSQL_SID' | memps => 'ps -edf | grep mysql-monitor-agent | grep $MYSQL_SID' | ||
CFG => 'cd $MYSQL_HOME;vi -R my.cnf' | CFG => 'cd $MYSQL_HOME;vi -R my.cnf' | ||
| Line 43: | Line 49: | ||
log => 'cd $gvsqw_RootAdmin/logs; ls -ltr'; | log => 'cd $gvsqw_RootAdmin/logs; ls -ltr'; | ||
tmp => 'cd $gvsqw_RootAdmin/tmp; ls -ltr'; | tmp => 'cd $gvsqw_RootAdmin/tmp; ls -ltr'; | ||
| + | </pre> | ||
<br> | <br> | ||
Revision as of 00:26, 16 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} (expdbTools 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';
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';
