by Ramesh Natarajan on January 30, 2009
![[Around The Geek World] [Around The Geek World]](http://static.thegeekstuff.com/wp-content/uploads/2008/10/around-the-geek-world-1.jpg)
Around The Geek World is a monthly summary of interesting articles and news around the geek world with my brief comments.
by SathiyaMoorthy on January 28, 2009

This article is part of the ongoing Vi / Vim Tips and Tricks Series. As a programmer, you may do lot of repetitive tasks while coding such as:
- Adding file header
- Adding function/frame comment
- Including default code snippet
- Performing syntax check
- Reading documentation about a function
- Converting a code block to comment, and vice versa
The C-Support Vim Plugin offers easiest way to do all of the above, saving lot of time and keystrokes for C and C++ programmers.
(more…)
by Ramesh Natarajan on January 26, 2009
For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities.
In this article, let us review how to start and stop an oracle database.
(more…)
by Ramesh Natarajan on January 23, 2009
1. What is PoE – Power Over Ethernet?
Power over Ethernet (PoE) does exactly what it says — it carries power over ethernet cables. So, an ethernet cables caries both data and current together to operate devices like wi-fi access points. This is very helpful to install wi-fi access points in ceilings, where it is hard to find power outlets. Only smaller devices can be powered using the PoE, as it carries limited power over the ethernet.
(more…)
by Ramesh Natarajan on January 21, 2009
This is a guest post written by SathiyaMoorthy
pg_dump is an effective tool to backup postgres database. It creates a *.sql file with CREATE TABLE, ALTER TABLE, and COPY SQL statements of source database. To restore these dumps psql command is enough.
Using pg_dump, you can backup a local database and restore it on a remote database at the same time, using a single command. In this article, let us review several practical examples on how to use pg_dump to backup and restore.
(more…)
by Ramesh Natarajan on January 19, 2009

Update: Linux 101 Hacks eBook released. Get your copy.
I’m currently writing my first book. I’m almost done with the Linux 101 Hacks eBook that covers 101 practical examples on various Linux related functionalists. The 101 hacks mentioned in this book will help you build strong foundation in Linux. All hacks in this book are explained with appropriate Linux command examples that are easy to follow.
There are total of 12 chapters in this book. Hacks mentioned in 6 chapters are based on the articles that I’ve already posted on my blog. Hacks mentioned in rest of the 6 chapters are brand new.
(more…)
by SathiyaMoorthy on January 16, 2009

Using Vim Macro feature you can record and play a sequence of actions inside the editor.
This article explains how to perform record and play inside Vi and Vim editor using two detailed examples.
(more…)
by Ramesh Natarajan on January 14, 2009
In all the 15 mysqladmin command-line examples below, tmppassword is used as the MySQL root user password. Please change this to your MySQL root password.
1. How to change the MySQL root user password?
# mysqladmin -u root -ptmppassword password 'newpassword'
# mysql -u root -pnewpassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.25-rc-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
(more…)