Thursday, October 31, 2013

Online avro phonetic typing - বাংলা


Press Ctrl+m to switch between English and avro-phonetic bangla typing.
Hit Space, Enter or Tab to transliterate.


AUTHOR: OBSCURE

Tuesday, October 22, 2013

Transfer big file with scp without blocking console and see progress

Problem statement:
  1. I must move a large file from one host to another, I used scp for it.
  2. But I need to use it without blocking console so that I can exit the terminal, so I should use nohup with scp and &.
  3. But I wanna see progress after some time. 
After searching solution for this I found the screen. To transfer file with scp without blocking console:
  • Step 1:
    execute this line to transfer file to remote host
    • This command will prompt for a password, give remoteHost's password.
  • Step 2:

Monday, October 7, 2013

Export and Import MySQL database from terminal

Below code will export MySQL database to a file and import it to another MySQL database from the file.


















AUTHOR: OBSCURE

Install and configure MySQL database for Cent-OS

Following are the command to install and configure MySQL in Cent-OS.



If the log-in and all other privileges is needed from ip-address other than the localhost following command needed to execute depending on what is needed:





AUTHOR: OBSCURE

Thursday, July 4, 2013

How to find duplicate values, and occurrences count in Oracle Database?

the easiest SQL query which will return the duplicate value and count for a given column is as follows:




















AUTHOR: OBSCURE

Tuesday, June 4, 2013

How to start a java program without the console in windows?

Write the following code in a "bat" file. Now double click on the batch file to run the jar.



PS: replace the path of jar with your desired jar path.

AUTHOR: OBSCURE

Monday, June 3, 2013

View PIDs and command lines of all running Java processes in Windows

The following line will shows PIDs of all running Java processes in cmd:


and to kill a process from windows cmd:




AUTHOR: OBSCURE

Sunday, June 2, 2013

Unicode characters are showing as question mark(?) instead of real value in nusoap webservice client.

Web service send correct unicode characters, but nusoap converts them to question mark(?). Solution is, adding the following lines after creating nusoap client



AUTHOR: OBSCURE