/kb

GRANT ALL PRIVILEGES ON thedatabase.* TO 'theusername'@'localhost'
	IDENTIFIED BY 'thepassword' WITH GRANT OPTION;

UPDATE 20080916: Skip the last line if the user exists.

find is an extremely powerful command. In order to leave the directory matching *DIRECTORY* out from your search for .txt-files:

find . -path '*DIRECTORY*' -prune -o -iname '*.txt' -print

If you’re using xargs together with find and xargs complains about file names with spaces, use:

find . YOURFINDOPTIONSHERE -print0 | xargs -0 rm -rf

Finding files larger than a certain limit:

find . -size +200M -print0 | xargs -0 ls -lh

Deleting the complementary files:

find . ! -name "*.mp3" -delete

Courtesy of HÃ¥kon.

Please note that these commands pertains to the BSD find as on Mac OS 10.5.

UPDATE 20080517: Looking for file size
UPDATE 20080602: Added deleting complement

It’s very easy, but I always have to look it up.

mysqldump --opt -u USERNAME -p -h HOST.HOST.COM DATABASE_TABLE > DUMPFILE.sql

There are numerous pages and blog posts about Vi and Vim out there so here’s my small contribution. Here are some less frequently used commands that tends to be useful from time to time:

:g/pattern/d

g;

g,

mLETTER

'LETTER

gU

gf

:/pattern/yank A

"ap

C-w -

C-w +

C-w =

By putting print_r() statements enclosed by html pre-tag, the output is quite a lot more readable.