Mysql Command Line.

Mysql Command Line. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. mysql> create database [databasename]; List all databases on the sql server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the db....
Continue reading

Apache Undergoing graceful restart automatically

We faced the following issue as “Apache Undergoing graceful restart automatically”, similar to apache was getting restarted gracefully every two hours. #grep graceful /usr/local/apache/logs/error_log Tue Oct 15 16:16:08 2013] [notice] Graceful restart requested, doing restart Tue Oct 15 18:12:53 2013] [notice] Graceful restart requested, doing restart Tue oct...
Continue reading

How to create mail account/user in postfix

This tutorial will help you to create mail user/account at postfix mail server 1. First of all you have to build a system user and a password: #useradd info #passwd info Then run 2. Then you have to tell Postfix to transport emails to a user’s Maildir: #postconf...
Continue reading

Mytop open source tool to monitor Mysql

Mytop is the most excellent open source tool to monitor Mysql strength, current running queries, no of sleep process, mysql load etc. To install Mytop open source tool to monitor Mysql use the following steps. First of all , we need to install few prerequisites to maintain mytop...
Continue reading

Categorized Tag Cloud