So I Won't Have To Remember

Home

Extract part of file using SED

Thursday, May 6, 2010

To extract part of a hugh file you can use SED. For example to extract from line 10,000 to 20,000 you do this :

sed -n 10000,20000p file.log

Posted by Posted by WL at 1:24 PM
Categories:
0 comments

Concatenate PDFs in linux

Wednesday, May 5, 2010

To concatenate PDFs use ghost script this way

gs -dBATCH -dNOPAUSE -q -sDEVICE=pdfwrite -sOutputFile=output-file.pdf p1.pdf p2.pdf

Posted by Posted by WL at 12:44 PM
Categories:
0 comments

MySQL: How to delete/update from a table with subqurying from same table

Thursday, January 28, 2010

   UPDATE customer_address SET default_address =1 WHERE address_id = ( 
   SELECT MIN(address_id) FROM (SELECT * FROM customer_address) AS temp
   WHERE customer_id =5 )

Posted by Posted by WL at 3:21 PM
Categories:
0 comments

Search and kill a process in linux

Monday, January 25, 2010

ps -ef | grep -i {process-name} | grep -iv grep | head -1 | awk '{print $2} | xargs kill -9

Posted by Posted by WL at 12:31 PM
Categories:
0 comments

Mount ISO image in linux

mount -t iso9660 -o loop disk1.iso /mnt/disk

Posted by Posted by WL at 12:24 PM
Categories:
0 comments

Mysql Initial Administration:

Add a user :

create user 'user'@'%' identified by 'pass';

Grant privileges :

grant all privileges on *.* to 'user'@'localhost' with grant option;
flush privileges

Set root password for the first time :

mysqladmin -u root password NEWPASSWORD

Posted by Posted by WL at 12:23 PM
Categories:
0 comments

Install vnc server on old linux machines with XF86Config

1. modify XF86Config and load module "vnc"
2. copy over vnc.so to /usr/X11R6/lib/modules/extensions/
3. add Option "SecurityTypes" "None" to Screens section to disable authentication

Posted by Posted by WL at 12:21 PM
Categories:
0 comments