Linux

Learning about Linux and Unix system

Backup MySQL databases automatically

AutoMySQLBackup is a great script that help us backup MySQL databases automatically. It can run thru cron job in or manually. It is easy to setup and make it works. I have just get it works only 5 minutes. The script uses mysqldump to backup MySQL databases so make sure you have it at your linux server/vps.

It is an open source/freeware so you are free to place it at your server/vps to backup your MySQL databases daily, weekly, monthy or manually.

AutoMySQLBackup features

Installing Postfix/Dovecot with SMTP-AUTH and TLS on CentOS

Postfix is a free open source mail transfer agent (MTA), a computer program for the routing and delivery of email. It is intended as a fast, easy-to-administer, and secure alternative to the widely-used Sendmail MTA. Formerly known as VMailer and IBM Secure Mailer, it was originally written by Wietse Venema during a stay at the IBM Thomas J. Watson Research Center, and continues to be actively developed today. Postfix was first released in mid-1999.

Compiling and Installing MySQL on Linux/CentOS

Download MySQL Source Code from http://dev.mysql.com/downloads/

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> bin/mysqld_safe --user=mysql &

----
yum install ncurses-devel
yum install gcc gcc-c++

Changing MAC address In Windows XP/Vista and Linux

There are many tools that let you change your MAC address. Most of them are commercial softwares. Of course, you also find the free or open source softwares on the internet. I searched before but i did not be happy with them. They are not as good as i expected. I need a small software to change my MAC address but it was developed into big software for a small task.

Linux commands

I have worked on Windows for long time. It is time that i am going to use Linux as my server, I will host most of server applications as web server, source code control, project management system... on Linux.