Back up and Restore MySQL database from the command line

Backing up via the command line:

Type the following at the prompt with the appropriate USERNAME and DATABASE name:

mysqldump -u USERNAME -p DATABASE > dump.sql

You will be prompted for your database password and then the DATABASE will be dumped to a plain-text file called dump.sql.

Restoring via the command line:

First drop and recreate the database as needed:

Drop the database

mysqladmin -u USERNAME -p drop DATABASE

Recreate the database

mysqladmin -u USERNAME -p create DATABASE

Import the backup data

mysql -u USERNAME -p DATABASE < dump.sql

Linux: Setting JAVA_HOME for a single user and all users

Here is how to setup JAVA_HOME and PATH environment variables for a single user or all users on Fedora Linux system

Setting JAVA_HOME and PATH for a single user

# vi ~/.bash_profile
# export JAVA_HOME=/opt/jdkx.x.x_xx
# export PATH=$PATH:$JAVA_HOME/bin

Setting JAVA_HOME and PATH for all users

# vi /etc/profile
# export JAVA_HOME=/opt/jdkx.x.x_xx
# export PATH=$PATH:$JAVA_HOME/bin

Creating Linux style symbolic links in Windows Vista

Windows Vista supports symbolic links (soft links). One way of creating these links is using the command line utility called MKLINK.

Run Command Prompt and type the comman MKLINK.

If the system warns saying…“You do not have sufficient privilege to perform this operation”. Run the Command Prompt as Administrator


MKLINK [[/D] | [/H] | [/J]] Link Target
        /D      Creates a directory symbolic link.  Default is a file
                symbolic link.
        /H      Creates a hard link instead of a symbolic link.
        /J      Creates a Directory Junction.
        Link    specifies the new symbolic link name.
        Target  specifies the path (relative or absolute) that the new link
                refers to.

Example: To create a directorty link called src what points to c:\users\foo\src

     mklink /D src c:\users\foo\src
Thats it!

Top 4 micro-blogging tools – Twitter, Pownce, Tumblr and Jaiku


Twitter is a free social networking and micro-blogging service that allows users to send updates (otherwise known as tweets) which are text-based posts of up to 140 characters in length.
Updates are displayed on the user’s profile page and delivered to other users who have signed up to receive them. The sender can restrict delivery to those in his or her circle of friends (delivery to everyone being the default). Users can receive updates via the Twitter website, instant messaging, SMS, RSS, email or through an application such as Twitterrific or Facebook.


Pownce is a free social networking and micro-blogging site started by Internet entrepreneurs Kevin Rose, Leah Culver, Daniel Burka.[2] Pownce is centered around sharing messages, files, events, and links with already-established friends. The site launched on June 27, 2007, and was opened to the public on January 22, 2008.


tumblr is a tumblelog site. A tumblelog is a variation of a blog that favors short-form, mixed-media posts over the longer editorial posts frequently associated with blogging. Common post formats found on tumblelogs include links, photos, quotes, dialogues, and video. Unlike blogs, tumblelogs are frequently used to share the author’s creations, discoveries, or experiences while providing little or no commentary.


Jaiku is a social networking, micro-blogging and lifestreaming service comparable to Twitter. Jaiku was founded in February 2006 by Jyri Engeström and Petteri Koponen from Finland and launched in July of that year. It was purchased by Google on October 9, 2007.