Wednesday, May 19, 2010

Scrolling while using screens

I had missed this for long:

If you are using screen and you want to scroll through the terminal use the following sequence:

ctrl+a [

After this you can use the arrow keys or ctrl + u,b etc

http://www.samsarin.com/blog/2007/03/11/gnu-screen-working-with-the-scrollback-buffer/

Monday, May 3, 2010

mysql Dumps!

mysql> SELECT * FROM  INTO 
OUTFILE '' FIELDS TERMINATED BY ',';

We can use below query for importing data from .txt file

mysql> LOAD DATA INFILE  INTO 
TABLE ''
FIELDS TERMINATED BY ',';