January 2009

Around The Geek World – Jan 2009

by Ramesh Natarajan on January 30, 2009

[Around The Geek World]

Around The Geek World
is a monthly summary of interesting articles and news around the geek world with my brief comments.

{ 1 comment }

Tutorial: Make Vim as Your C/C++ IDE Using c.vim Plugin

by SathiyaMoorthy on January 28, 2009

Vim as C/C++ IDE
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…)

{ 12 comments }

Oracle Database Startup and Shutdown Procedure

by Ramesh Natarajan on January 26, 2009

Oracle Flight Logo
Photo courtesy of Rob Shenk


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…)

{ 2 comments }

RJ45 Ethernet Cable
Photo courtesy of Olivander

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…)

{ 0 comments }

PostgreSQL DB Backup and RestoreThis 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…)

{ 11 comments }

Free eBook: Linux 101 Hacks

by Ramesh Natarajan on January 19, 2009

Linux 101 Hacks Book
 
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…)

{ 10 comments }

Vi and Vim Macro Tutorial: How To Record and Play

by SathiyaMoorthy on January 16, 2009

Vim Macros - Record and Play
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…)

{ 37 comments }

MySQL LogoIn 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…)

{ 11 comments }