Linux commands for mysql

tail -100f catalina.out
less catalina.out
----> to show the file (eg.catalina.out)


cat>f.name (press enter and ctrl+c) -->cleanup process

../bin/startup.sh instead of cd .., cd /bin/startup.sh

cp /home/cit146/Ayyachamy/pro/yumeetl/tmp/yumemetl_27_11_2008_04_13_binary.jar --> curent location to /home/cit146.......


rm -rf catalina.OUT ---> remove a file

cat server.xml | grep "grep used for searching purpose

cat server.xml | grep "wc -l

ps -ef | grep tomcat --->show how many tomcat are running

kill -9 8738

88]# scp server.xml root@192.168.1.146:/usr/local ---> copy a server.xml from 192.168.1.88 to 192.168.1.146

mysql>show processlist --> How many process ran in the current databas