Formatting Output from MySQL prompt

Posted on Wed 23 September 2009 in misc • Tagged with mysql

I'm not the biggest fan of MySQL and on the occasions I do use it I always forgot how to get useful results from my queries. To get results paged to less and have them display vertically, you can do this

mysql> \P less
PAGER set to 'less'

mysql> select …

Continue reading

Restore Mysql Database from the .frm .MYI and .MYD files

Posted on Wed 23 September 2009 in misc • Tagged with mysql

OK so you have a mysql database that you have recovered from a backup. However, whereas you would normally have a nice sql dump to deal with, on this occasion you only have the .frm .MYI and .MYD files. Can you rescue that table the client has deleted? Indeed you …


Continue reading

Essential HPing3 and TCPDump

Posted on Mon 21 September 2009 in misc • Tagged with tcpdump, hping

HPing3

Send 2 syn packets to port 80 on a host

hping3 -c 2 -S -p 80 example.com

scan a some specific ports on host sudo hping3 -S example.com --scan 143,220,993,25,80

TCPDump

capture packets on -ivenet0 interface, don't resolve addresses or port name (-nn …


Continue reading

Setting-up Pylons in 5 mins

Posted on Mon 21 September 2009 in misc • Tagged with Pylons

Really just a recap of http://pylonshq.com/docs/en/0.9.7/gettingstarted/#installing

Here we go:

#> wget http://www.pylonshq.com/download/0.9.7/go-pylons.py
#> python2.6 go-pylons.py mydevenv

Everytime we work on a virtual pylons installation run the following script

#> source mydevenv/bin/activate …

Continue reading

Building Python from Source

Posted on Mon 21 September 2009 in misc • Tagged with Python

How easy it is to install python from source? Very.

./configure --prefix=/usr/local/python2.6/
make #(took 4mins on my x86_64 dc)
make install

Continue reading