restart service predefined scripts (cPanel)

There is some restart service predefined scripts come with cPanel with is MUST KNOW by all the server admin.

How to use it? Just log into SSH and use the command /script/restartsrv_ follow by the bold word as below.

Web Service:
apache — Apache web server.
httpd — Apache web server.
tomcat — Apache Tomcat service

DNS Service:
bind — BIND nameserver software.
named — BIND nameserver software.

Email Service:
cppop— cPanel’s POP server.
imap — IMAP server.
dovecot — Dovecot mail server.
courier— Courier mail server.
exim — Exim mail exchanger.
eximstats — Exim mail statistics tracker.
spamd — Spam-deferral daemon.

Cpanel Service:
chkservd — cPanel’s TailWatch log processing service.
clamd — ClamAV anti-virus software.
cpdavd — cPanel’s WebDAV server.
tailwatchd — cPanel’s TailWatch log processing service.
sshd — Secure shell daemon.

FTP Service:
ftpserver — FTP server.
proftpd — ProFTP server daemon.
pureftpd — Pure-FTP server daemon.

Database Service:
mysql — MySQL database server.
postgres — PostgresSQL database service.
postgresql — PostgreSQL database service.

How to attach your local drive to RDP

(1) Open Remote Desktop Connection

(2) Click on Option

(3) Select Local Resources

(4) Click on the More button under the Local devices and resources

(5) Tick on your Drive

(6) Then connect

After login, you will see your local drive in your server.

How to get mysql current time

In Mysql, there have a function to store the time by default. It will same with server time usually, but how to confirm it?

Just use the command as below

mysql> SELECT NOW();
| NOW() |
| 2011-08-26 10:57:30 |