How to rename table in mysql using command line

How to rename table in mysql using command line

In this post we will know how to rename table in mysql using command line. It is basic and important command for MySQL database administration. We are doing this practical in MySQL server version 5.5.29. Syntax: Replace the table_name and NEW_TABLE_NAME as per your requirement. ALTER TABLE table_name RENAME NEW_TABLE_NAME Example: See the below given…

Easy and quick installation of VirtualBox 4.2.10 in Linux Mint Olivia
|

Easy and quick installation of VirtualBox 4.2.10 in Linux Mint Olivia

In this post we will learn easy and quick installation of VirtualBox 4.2.10 in Linux Mint Olivia. There are two ways to install any packages (1) Command line (2) Graphical (Using Software Manager) We mostly prefer to work in command line because it is faster as well as if there is any error it is…

How to install and configure HAProxy 1.4.24 in CentOS 6
|

How to install and configure HAProxy 1.4.24 in CentOS 6

In this topic we will learn how to install and configure HAProxy 1.4.24 in CentOS 6.HAproxy is widely used Open Source tcp/http based loadbalancer.And many renowned company also using the HAProxy.Here in this tutorial we will install the latest stable HAProxy version 1.4.24 in CentOS 6.4. We recommend to install latest stable version 1.4.24, read…

How to configure static ip address through command line in Ubuntu

How to configure static ip address through command line in Ubuntu

In this tutorial we will learn simple steps to configure the static ip address in Ubuntu by using command line. It is always be a good practice to work on Linux or Unix system using command line.As a system admin we always prefer to work by using command line. Follow the given below steps to…

how to mount NAS storage in owncloud to keep all users data
|

how to mount NAS storage in owncloud to keep all users data

In this post I am sharing about how I mounted the NAS storage in owncloud to keep all users data in it. I checked the External Storage application of owncloud but here our requirement is we want to keep all data in NAS storage and user should not save anything in Owncloud Server’s disk. The…

postgres database backup  script using database user password inside
|

postgres database backup script using database user password inside

Postgresql is open source object-relational database system and it is also widely use likewise mysql database system. If you are familiar with mysql you must be aware that in single line you can pass the password of mysql user for eg. mysql -u root -p password. But in postgresql it is not like that. Solution:…

hash:/etc/postfix/virtual is unavailable. open database /etc/postfix/virtual.db: No such file or directory

hash:/etc/postfix/virtual is unavailable. open database /etc/postfix/virtual.db: No such file or directory

Few days back I did some changes in /etc/postfix/virtual file and restarted the postfix service.Today I saw some error in mail logs stating “hash:/etc/postfix/virtual is unavailable. open database /etc/postfix/virtual.db: No such file or directory” I checked /etc/postfix/virtual.db about its existence by using command ls -l /etc/postfix/virtual.db and found it was not there. To resolve this…

How to zip directory in linux explained with examples
|

How to zip directory in linux explained with examples

Zip is command in linux is used for compressing files and directory.In this post we will learn how to zip the directory or folder in linux. To compress directory use the below given format zip -r give-file-name.zip Directory-name example: root@tuxworld:/opt# ls -ld teamviewer8/ drwxr-xr-x 6 root root 4096 Oct 2 08:43 teamviewer8/ root@tuxworld:/opt# zip -r…

How to enable logging of haproxy in rsyslog

How to enable logging of haproxy in rsyslog

After installing the HAproxy 1.4 in CentOS 6.4 bydefault logging of haproxy was not enable.To enable the logging of HAProxy you have to enable it in rsyslog (In CentOS 6.4 minimal installation,rsyslog version 5.2 is shipped). To setup logging in HAproxy,follow the given below steps Step 1: In Global Section of haproxy.cfg put the value…