Welcome to my blog. I write instruction guides and how-to's on Linux, database, hardware, security and web. To keep up-to-date with my posts you may want to sign-up to receive blog posts by email or subscribe to my RSS feed. Thanks for visiting and I hope you enjoy my articles.

Your interaction with Linux Bash shell will become very pleasant, if you use PS1, PS2, PS3, PS4, and PROMPT_COMMAND effectively. PS stands for prompt statement. This article will give you a jumpstart on the Linux command prompt environment variables using simple examples.
[Read more →]

MyISAM is the default storage engine for MySQL database. MyISAM table gets corrupted very easily. In this article, I’ll explain how to use myisamchk to identify and fix table corruption in MyISAM. When a table is created under MySQL, it creates three different files: *.frm file to store table format, *.MYD (MyData) file to store the data, and *.MYI (MyIndex) to store the index. I prefer to use InnoDB as the storage engine for bigger database, as it resembles Oracle and provides commit, rollback options.
[Read more →]

This article is part of on-going Software For Geeks series. PuTTY is hands-down the best, free, and lightweight SSH client for Windows. I have provided list of 12 powerful PuTTY add-ons with screenshots, that will solve few shortcomings of the original PuTTY.  Play around with these add-ons and choose the one that suites your need.
[Read more →]

Oracle offers Linux distribution, that is based on Red Hat Linux. Should you use Oracle Linux Distro? I’ll provide appropriate information that will help you to answer this question. I have also provided screenshots of a Linux upgrade using Oracle Enterprise Linux.
[Read more →]

After you have installed Apache2, if you want to use apachectl and httpd to it’s maximum potential, you should go beyond using start, stop and restart. The 9 practical examples provided in this article will help you to use apachectl and httpd very effectively.
[Read more →]

If you are managing more than one equipment in your organization, it is very important to document and track ALL information about the servers effectively. In this article, I have listed 36 attributes that needs to be tracked for your equipments, with an explanation on why it needs to be tracked. I have also provided a spreadsheet template with these fields that will give you a jumpstart.
[Read more →]

Most of the open source application uses MySQL database. To debug an issue with the open source application, it is very important to understand how to quickly get high level information about your MySQL database. In this article, I have explained how you can view the database, table, column and index information on any MySQL database using 9 examples.
[Read more →]

When you are using Linux command line frequently, using the history effectively can be a major productivity boost. In fact, once you have mastered the 15 examples that I’ve provided here, you’ll find using command line more enjoyable and fun.
[Read more →]

Most of you might have enabled wireless encryption, which is only one of the 6 steps mentioned in this article to make your wireless network safe and secure from hackers.  The screenshots mentioned below are from Linksys wireless router. But, you’ll find similar options for all the 6 steps mentioned below in wireless routers from any other vendors.
[Read more →]

As part of Software for Geeks on-going series, earlier I wrote about Web based To-Do List Software. In this post, let us review about Web based time tracking software. For geeks to be ultra efficient and productive, it is very important to cut down the time spent on activities that are not aligned with your goals. If you track daily activities either manually or using some software, you will be surprised to find out how much time your may be spending on activities that don’t need such attention. Take a test drive of the following two free online time tracking software and pick the one that suites your need.
[Read more →]