LAMP

rpm -qa

rpm -va

rpm -qa | grep php

ps aux

netstat -an | grep LISTEN -To see which ports are Open

ln -s php-3.0.12 php

./configure --with-mysql=/usr/local/mysql --with-config-file-path=/www/conf --with-apache=../httpd --enable-track-vars

RPM Commands

To install a RPM package, use the command:

 [root@deep] /#rpm -ivh foo-1.0-2.i386.rpm

To uninstall a RPM package, use the command:

 [root@deep] /#rpm -e foo

To upgrade a RPM package, use the command:

  [root@deep] /#rpm -Uvh foo-1.0-2.i386.rpm

To query a RPM package, use the command:

   [root@deep] /#rpm -q foo

To display package information, use the command:

  [root@deep] /#rpm -qi foo

To list files in package, use the command:

 [root@deep] /#rpm -qlfoo

To check a RPM signature package, use the command:

 [root@deep] /#rpm  --checksig foo

This command checks to determine which installed package a particular file belongs t

 rpm -qf /usr/bin/mysql
This command will list all files that do NOT pass
 the verify tests (done on size, MD5 signature, etc).

rpm --verify mysql

SQL Query to get records of Last 30 days

SELECT TOP 3 Id, Title, SubTitle, Place, CONVERT(varchar(15), Rdate, 106) AS Rdate, Content, Address, About, Comments FROM tbl_PressRelease WHERE (Rdate > DATEADD(day, - 30, GETDATE()))ORDER BY Id DESC

Google Language translator

http://64.233.179.104/translate_c?langpair=en|ru&u=http://www.nmeinc.com

64.233.179.104-google.com
en-English
|-to
ru-Russian
u-URL