flimflam

ssh-agent keychain guide

http://www.gentoo.org/doc/en/keychain-guide.xml

%s/UNHEX(MD5(\(.\{-}\))/UNHEX(MD5('\1')/g

use \{-} instead of *

enable multiverse, universe repos

vim /etc/apt/sources.list

append universe multiverse to the end of each

sudo apt-get update

sudo apt-get install sun-java6-jre

git reset --soft HEAD^

http://stackoverflow.com/questions/927358/git-undo-last-commit

python manage.py sqlall <<app>>

iptables -t nat -A PREROUTING -p tcp -s ! _SERVERIP_ --dport 80 -j REDIRECT --to-ports 81

test

when creating new users, make sure to create a default 'user'@'localhost' for every 'user'@'%'

restart mysql after creating new users

for remote mysql, add the ip to iptables! aha!

-A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT

/usr/local/mysql-5.1.31-osx10.5-x86/bin/mysqldump -u xxx -h xxx -p db_name > /tmp/db.sql

mysql -u xxx -h xxx -p db_name < /tmp/db.sql