Monday, November 1, 2010

Backing up and restoring a mySql database

1. Create backup

$ mysqldump -u root -proot regdb > /home/yumani/Documents/regdb_back.sql


2. Restore

Create a database in mysql and the grant user access
mysql >  create database regdb;
mysql >  grant all on regdb.* to wso2bam@'%' identified by 'wso2bam';

$ mysql -u root -proot regdb < /home/yumani/Documents/regdb_back.sql

Tuesday, October 12, 2010

Removing mySQL

sudo apt-get remove mysql-server
sudo apt-get autoremove mysql-server
sudo apt-get --purge remove mysql-server

same for mysql-client.

Thursday, July 1, 2010

Setting-up and accessing Derby DB in Ubuntu

1. Download Derby bin distribution from here.

2. Extract it.

3. Set DERBY_HOME and add it to the path.
vi ~/.bashrc

Add as below;
export DERBY_HOME=/opt/software/db-derby-10.3.1.4-bin
export PATH=$PATH:$DERBY_HOME/bin

Then source bashrc
source ~/.bashrc


4. Run $DERBY_HOME/bin/startNetworkServer.sh
sh startNetworkServer

5. To use ij tool;
set DERBY_OPTS=-Dij.protocol=jdbc:derby://localhost/

Then type ij on the prompt to get the ij tool, where u can type in commands.


Monday, June 14, 2010

Notes on Cloud!

Did a little lazy work.. Below is some notes I directly copied from an IBM white paper (soucre is given below).

Source :
Dispelling the vapor around cloud computing Drivers, barriers and considerations for public andnprivate cloud adoption                             
IBM Smart Business
Thought Leadership White Paper
January 2010


What is cloud computing?

Cloud delivery models:


Features:
Cloud based service management capabilities that are essential:

Main elements in cloud architecture:

Sunday, June 13, 2010

How-to-make-awesome-tag-cloud

Excellent guide with simple steps - http://blog.frivolousmotion.com/2007/05/how-to-make-awesome-tag-cloud.html

Friday, June 11, 2010

VMware player in Ubuntu9.10

VWware player is a graphical interface tool which lets you open vm images.

To intsall this in ubuntu;

1 -  You need to download VMPlayer (VMware Player for 32-bit Linux) from vmware website.

2 - apt-get the pre-requisites
sudo apt-get install build-essential linux-headers-$(uname -r)
 
3 - Give executable rights to the .bundle file that you downloaded in step 1
chmod +x VMware-Pl*.bundle
 
4 - Run the installer
gksudo bash ./VMware-Player*.bundle
  
After its installed, you can access VMware Player from Applications > System Tools > VMware Player
 
 
  

Monday, June 7, 2010

SSH commands

To connect from your local machine:
ssh -l username ipaddresss
  
To copy a file to a directory on a remote system:
scp filename username@host:path
 
filename - the name of the file to be uploaded to the remote system,
username - the name of user account to be used to log into the remote system,
host - the real IP address or hostname of the system,
path - the directory into which the file should be copied.
 
To copy from the remote system to the local system:
scp username@ehost:path/filename


source: http://www.techotopia.com/index.php/Configuring_Ubuntu_Linux_Remote_Access_using_SSH

Thursday, June 3, 2010

WASP

WASP is a powerful web application framework built on PHP 5. WASP strives to allow web developers to make great applications with more fun and less code, but in the familiar playground of PHP.

WASP was written from the ground up in pure Object Oriented PHP5. WASP fully utilizes all of the enhancements made to PHP in version 5.

Thursday, May 20, 2010

NoSQL

Came across the term "NoSQL" from one of the mail threads in WSO2 carbon-dev mailing list.

What is NoSQL, I didn't know it. Even wondered whether its a typo :p... can't obviously be. So googled;

Here's the wikipedia intro (until I read more detailed stuff later);

"NoSQL is a movement promoting a loosely defined class of non-relational data stores that break with a long history of relational databases. These data stores may not require fixed table schemas, usually avoid join operations and typically scale horizontally. Academics and papers typically refer to these databases as structured storage.
Notable production implementations include Google's BigTable and Amazon's Dynamo. However, there are also many publicly available open source variants including HBase and Cassandra."


REFERENCE: 
NoSQL. (2010, May 14). In Wikipedia, the free encyclopedia,retrieved 21 May 2010, from http://en.wikipedia.org/wiki/NoSQL

Wednesday, May 12, 2010

Day 03 Gala Dinner Highlight Video