In this video tutorial you will learn about default configuration file my.cnf for mysql server. you can add / change various configuration parameters in this file so that when ever you restart server, new configuration values will get in effect.
On Ubuntu /etc/mysql/my.cnf OR on centos / redhat / fedora it is /etc/my.cnf

http://www.youtube.com/watch?v=brQ0sRbY1VU&feature=youtu.be
OR
http://www.dailymotion.com/video/x10t024_mysql-video-tutorial-my-cnf-bro...

[mysqld]
user = mysql
port = 3306
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld.sock

This video tutorial will teach you about various / different command line (CLI) options available with mysql command to connect to mysql-server.
–user is same as -u
–host is same as -h
–password is same as -p
–port is same is -P (this is upper case P) for port
–help | -? for more options i.e mysql –help
-e — execute sql statement from command line mysql -e ‘show databases;’
-D –database – select particular database
-H –html — produce output in html format
-X –xml — produce output in xml format
-t –table — produce output in table format

Hi Friends,
In this article we will learn how to configure sendmail so that you can log "Subject" in /var/log/maillog as by default sendmail does not log Subject to maillog file.

This short how to will show how to disable a user account under linux. This might be useful in the situation where you don’t want to permanently remove the user, but you just want it disabled and no longer able to use the system. The user will still receive emails for example, but he will not be able to login and check them out.

This short how to will show how to disable a user account under linux. This might be useful in the situation where you don’t want to permanently remove the user, but you just want it disabled and no longer able to use the system. The user will still receive emails for example, but he will not be able to login and check them out.

By default in mysql database server max_connections is set to 100. This value indicates how many maximum concurrent connections mysql server can handle. If mysql reaches to it maximum (max) limit then you can see errors like "too many connections". I assume that you have enough hardware resources (Mainly RAM )to handle more connections, here with this article I will share a TIP to increase max_connections in mysql.

As we know my.cnf is default configuration file for mysqld service and by default it is located in /etc directory unless and until you have changed it.

Hi all, In this article we will learn how to install amanda backup server and cofigure it to start taking backups. It is completely free and based on GPL License. we don't need to pay any license fee to use this software in live/production environment.

Steps to install amanda backup server.

1. Install centos 5.2 x86_64.
2. Get rpm from www.amanda.org/download.php for latest stable version of amanda server. E.g amanda-backup_server-2.6.1p2-1.rhel5.x86_64.rpm
3. install this downloaded rpm using #rpm –ivh command
   

PostgreSQL Cheat Sheet

CREATE DATABASE

CREATE DATABASE dbName;

CREATE TABLE (with auto numbering integer id)

CREATE TABLE tableName (
 id serial PRIMARY KEY,
 name varchar(50) UNIQUE NOT NULL,
 dateCreated timestamp DEFAULT current_timestamp
);

Add a primary key

ALTER TABLE tableName ADD PRIMARY KEY (id);

Create an INDEX

CREATE UNIQUE INDEX indexName ON tableName (columnNames);