The One

From the past 20 years, I have been searching for THE ONE, my perfect match. Legend says many a men live their entire life without finding THE ONE. Few, compromise with “ONE or MANY” they got and few, assume that the ONE they have is THE ONE. But whenever I find a ONE, back in my mind, behind the curtain, the little fella sitting on the stool, asks “is this THE ONE????” Till last weekend it was always the other ONE. But last weekend, a miracle happened. I have been to shopping and I find a ONE at the mall. And today when we are together for the first time, I realized that I met THE ONE of my life. Every step I took with THE ONE on the aisle was like a swing in the clouds. From morning my heart is beating with a rhythm of jubilant feeling, my soul is doing salsa all the time. It’s awesome to be with THE ONE. 

Weekend Buzz....

I have been to Ind-SL third test match(day-4) at Breborne last weekend. I would like to share the trivia here.

Sad: Sachin fielded at deep cover point/backward (who was farthest from our stands :( )

Happy: Where as Sehwag/Sreesanth fielded in deep mid wicket/square leg (who was closest to our stands :) )

Boost:  Sreesanth was interactive with audience (waving at them, giving thumbs up to them)

Dismay: Where as Sehwag was very dissociated with audience.

Observation: Sreesanth’s run-up was almost equal to the radius of the stadium, where as Zaheer’s was around 50% of that of Sreesanth's.

Deny: Almost 20,000 audiences appealed for an lbw to Harper whose response was a negative.

Phenomenon: SL lost five wickets on day-4. Out of which, one was before we stepped in the stadium, and one was after we stepped out of the stadium.

Comfort: Indian team was much disciplined in the ground. And eventually won the match :) :) :)

Mis(s)take...

OK, yes it's a mistake. I know it’s a mistake, but there are certain things in life where you know it’s a mistake but you don’t really know its mistake because the only way to really know it’s a mistake is to make the mistake and look back and say ‘yep, that was a mistake.’ So really, the bigger mistake would be to not make the mistake, because then you’d go your whole life not really knowing if something is a mistake or not. And damn it, I made no mistakes! I’ve done all of this; my life, my relationship, my career, mistake-free. Does any of this make sense to you?

It's Awesome Times Awesome...Awesome Square...

                  Ever since I was a kid, I have been passionate towards English language. I still can’t figure out the instinct that ignited impetuosity towards English language in me, and which made me a logophile!! There are umpteen people, movies and friends I adore; for their profound way of speech/dialogues and for their (creators) commanding knowledge on English language.

Till the first week of Oct’09, this movie stood right on top of my favorites list because of this character’s dialogues. But (I wonder why there is a BUT for everything in life?) in the first week of Oct’09 I met “How I Met Your Mother” aka “HIMYM” and it reached the top of the chart because of this character’s dialogues.

        It’s a sitcom aired by CBS. The plot is about the main character Ted Mosby; in the year 2030 recounts to his son and daughter the events that led to his meeting their mother (which explains the title), about his friends and the stuff they did in NY.I give two reasons why this TV series has reached the top of my favorites chart and why it has taken a place in my blog.

 1) Few dialogues, metaphors, and clichés used in this program are lame but the way they presented them are awesome and rib tickling.

2) Characterization; the characters Ted, Lily, and Marshall are loosely based on the characters of the show creators, which gave them, ease in chalking out the characters very natural and realistic.

Being a logophile, I asked many people “what could be the most beautiful word in English?” Finally this show answered me. It’s AWESOME.

Random thoughts about land contentions....

During my journey towards Hyderabad last week, I saw “హైదరాబాద్ మాది రా, ఫ్రీ జోన్ ఎక్కడిది రా” (Hyderabad is ours, its not a freezone), a red and bold sentence on a wall. That reminded me few incidents about contentions for land and my thoughts in regard. viz.,

1) In my childhood, my teacher told me that "Andhra Pradesh (AP) consists of three regions namely Telangana, Rayalaseema and Kostha Andhra". I didn’t ask “Why there are three regions within a single state?” (This was one of those thousands of questions that bugged my brain for longtime in childhood). In the intervening years, new parties germinated in AP with the Separate Telangana concept and made news all over the world. But teachers are still teaching that "AP consists of three regions". :). I deem, People, who knew the story about Berlin-Wall, may not encourage the segmentation of a state into multiple states and erect barriers.

2) Years passed and I joined in an IT company, in Mumbai. One day a friend of mine told me that a local party members created rampage in Shiridi against the people from AP, because those people were migrants. That incident reminded me the strifes about,

(*) MUMBAI name: formerly Mumbai was called as Bombay ( few months back a local party threw stones on BombayDyeing show room for not changing its name to MumabiDyeing...yet!!!),

(*) And the turmoil of migrants from UP, Bihar and southern parts of INDIA to Mumbai.

I want to torch light on one thing here; “The Likes of Gandhiji, Nethaji, and Alluri faught for the freedom of INDIA, not for the freedom of Gujarat, Orissa or AP”. Then in independent INDIA what these local parties are fighting for? And what they did when NSG (includes guards from different states of INDIA, not only Maharashtra) rescuing TAJ victims on 11/26?

3) Globalization happened (and is happening) in every field, so is in my observation. When I was watching “RAW is WAR” in my adolescent age (a famous wrestling program) I didn’t realize why people in that Madison Square Garden booing a wrestler, carrying a Canadian Flag. And in the recent past I saw a sitcom where a New Yorker disparaging a Canadian, Canada and even New Jersy!!!. I realized that America is also not saved from the contentions for land. (I need not mention anything about Jerusalem, NY-NJ conflicts exclusively here.)

The response of Saladin in conversation with Balian from the film Kingdome Of Heaven, “Nothing. [walks away, then turns around with a pained look] Everything!” soothes me whenever I think about these contestations.

P.S.: I know my HK friend has his say about this article.

Waving.....

I have been anticipating the Google Wave invitation from September 30^th (ever since the day it’s launched). Finally I got the invitation from a twitter friend couple of days ago. I tried to encapsulate few features of Wave in this article.

Google Wave is a web application that lets you easily communicate and collaborate with others. By Google Wave we can use the web to have conversations, share photos and files, work with others on documents, chat in real time, organize our information, post to blogs and more. It features tagging waves, dockable labels, personalized folders, Map gadgets, Yes/No/Maybe gadgets, Doctor Wave and many more.

Extension Gallery:  A Google Wave extension (gadget) lets you add rich content and integrate with other systems. There is a provision to install few extensions namely Wave Sudoku, Conference, Video Chat Experience, Trippy, AccuWeather.com, and etc.

Trippy: is an itinerary, where we can create and scheduled our trips, dates and share them friends. A sample trip to New Delhi in February is given below.

Sudoku Gadget:

There are many features, which I need to reconnoiter in Wave. I am willing to post more articles about the features of Wave in future. Meanwhile I would like to finish this article by a coinage often used by my friend. i.e., “Google is the best thing that has happened to us in this 21^st century”. :) 

P.S.: I will invite my friends to Wave, as soon as I get the credentials.

2 hours @hospital...

I came to the office this morning half-hour early and started my routine work. Few minutes later one of my colleagues (mentioned as struggler henceforth) came (apparently languish) and expressed that he was agonized by severe stomach-pain (@lower abdomen). I tried to console him, told him to lie down on the desk and take deep breaths. With a sweaty face he cried that the pain was unbearable and complained that he never experienced such hazardous pain in his life time. I googled about the "pain in stomach" and it showed the horrifying results related to appendicitis. I probed him about few symptoms of so called appendicitis, but his response was negative. Then I catechized whether he had suffered from problems related to kidney stones in the past. “Alien thing to me” was his response still holding the lower abdomen tight. I couldn’t see him suffer more, so went to security guard and took a “Cyclopam” pill as first-aid. He had the pill. After couple of minutes two more colleagues came, doubted the pain might be due to appendicitis carnage inside the stomach. And suggested a visit to Doctor will better the situation.

            Within minutes, the struggler, a helper and I were in “G****j Memorial Hospital”. I was in queue at out patient departure (OPD) for fifteen minutes, and then receptionist told me to fill a form as it is being our struggler’s first visit to their hospital. I was completely astonished, and recollected the memories of a famous film dialogue “form bharna jaroori hai kya?” (Is it mandatory to fill the form?). Having no choice, filled the form and paid the registration fee. Meanwhile, magical pill started doing wonders inside struggler’s stomach; he has been relieved greatly by then. We three sat near by door #3, where DR.X -the surgeon, was supposed to attend our struggler. The doctor’s name plate included a minimum of ten alphabets of English language; I remember only the last three letters U.S.A. A few minutes later, a house nurse came and suggested us to head towards casualty. By the time we entered the casualty, our struggler was no more a struggler. The doctor (I better address him as an RMP) in there couldn’t find who the patient among the three was. I helped him showing up the struggler. He did some normal check-ups and few stunts with BP APPARATUS confirmed the impish pain was beyond his limitations and referred us again to the surgeon at door #3. We three waited there for almost one-half hour. Meanwhile I recollected my past memories related to hospitals, Sidney Sheldon’s novel “Nothing Lasts Forever”, George Clooney’s television drama “ER”, and etc.

            At around 11:00AM our surgeon at door#3 arrived, checked his patient and suggested to get couple of pathology reports and the magical “Cyclopam” pill again incase of future stomach-ache.

            Then we three returned to the office and the rest his history.

P.S. Mr.Chetan Bhagat was inspiration of the title.

Experiments with My SQL....

Of late I am working with My SQL server, so wanted to share my hands-on experience with blogger world.

Topics covered:
1) How to check My SQL server is up or not and how to start the server.
2) Various command to login to the My SQL server.
3) How to change/reset/recover the root/user passwords.
4) How to take the dump of a My SQL database to a file and how to import it from a file.
5) Executing queries from shell.

Start and Stop….
1) You can check whether My SQL server is up or not by simple unix command given below.
$ ps –ef|grep mysql
The command will show the mysql process running or not.

If the My SQL server is not running, it is very simple to start, execute the following commands in shell prompt.
a) $cd /etc/init.d
b) $./mysql start
The above commands make the My SQL server up.

To stop the My SQL server use
$etc/init.d/mysql stop

Logging in….
2) We can login to the server by any of the below given commands.
a) Without database argument:

 $mysql –u root –p
In the above command –u signifies the option USER (in the command it is “root”) and –p signifies the option “database to be selected” (in the command we have not passed any argument). We will receive the prompt “Enter password:” give the corresponding password. Once we logged into the server it prompts “mysql>”, which is default, we can set the prompt to our desired one by the below command
mysql> prompt demo$
Prompt will be changed as shown below.
demo$

NOTE: In this article I have used default prompt for easier understandability.

We can see what are the databases existing in the server by following query.
mysql> show databases;

+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test1 |
+--------------------+
3 rows in set (0.00 sec)
Now we can select any database by the following query.
mysql> use [databse_name];

Example:

mysql> use test1;

b) With database argument:

$mysql –u r oot –p test1
We will receive the prompt “Enter password:” give the corresponding password. Here in this command database to be selected is given at command prompt only.

c) Now we see the single line login to My SQL server:
$mysql --user=[user] --password=[password[ [databse]

Example:
$mysql --user=root --password=abc123 test1
Note: “double hyphens” (--) are required in mentioning the arguments, no spaces are allowed before and after “equal to” (=) symbol and the value passed after the password (abc123 in this example) is taken as database to selected, which is optional.

Passwords….
3) If we have not set the root password for My SQL, the server does not require a password at all to login. To set the password for the first time use the following command in shell prompt.
$mysqladmin –u root password NEWPASSWORD

If we want to change the password, use the command given below
$mysqladmin –u root –p ‘oldpassword’ password NEWPASSWORD

  The same command can be used for changing the password for any user by mentioning the user id instead of “root”. For example to change the password for user “USER1” the command is as followed.
$mysqladmin –u USER1 –p ‘oldpassword’ password NEWPASSWORD

Or we can reset the password of any user using My SQL command prompt as shown below.
a) Login to the My SQL server
$mysql – u root –p
b) Select the databse
mysql> use mysql;
c) Change the password for user USER1
mysql> update user set password=PASSWORD(“NEWPASSWORD” )where user=’USER1’;
d) Reload the priviliges
mysql> flush priviliges;
mysql> exit

Even if we forgot the root password to login to My SQL database, we can login to database without the password, in the following way.

a) Stop the My SQL server process in shell
$/etc.init.d/mysql stop
b) Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password
$mysqld_safe –skip-grant-tables &
c) Connect to mysql server as the root user
mysql –u root
d) Setup new root password
mysql> use mysql;
mysql> > update user set password=PASSWORD(“NEWPASSWORD” )where user=’root’;
mysql> flush priviliges;
mysql> exit
e) Exit and restart MySQL server
$/etc.init.d/mysql stop
$/etc.init.d/mysql start
  And now we can login to database with the new password we just set.

Taking the database Backup….
4) There is one simplest way to take the back up of a database by the below given command
$mysqldump –u [user] –p [databse] > backupfile.sql
Example:
$mysqldump -u root -p test1 > Mysql_backupfile.sql
By the above command we take the back up of “test1” database to a file “Mysql_backupfile.sql”.

To restore the database from a file is quite easier. Use the command below
$mysql –u [user] -p [database_to_be_restored] < Mysql_backupfile.sql
Example:
$mysql -u root -p test1 < Mysql_backupfile.sql

Executing queries from shell….
5) We can execute the insert/update queries from command prompt by using the following command.
$mysql [databse_name] < [filename] -u [user] -p
Example:
$mysql test1 <  file1 -u root -p
Here in the file “file1” we can write our desired insert/update queries. (Each query terminated by a semicolon (;) and the next query in a new line). Execution of the command, prompts for the “root” user password, enter the corresponding password, the data in the “test1” database will be altered or inserted according to the queries given.

You can refer this link or contact me for any assistance in My SQL.