Change permission of directories

cd /var/files/test
find -type d -exec chmod 0777 {} \;

function getNumPagesInPDF($PDFPath = NULL)
 {
 $stream = fopen($PDFPath, "r");
 $PDFContent = fread ($stream, filesize($PDFPath));

Use 'ALT+SHIFT+A' et voilá ...

Soooo nice:

SELECT * FROM `menu` WHERE weight != 0 ORDER BY (CASE type WHEN 118 THEN 2 WHEN 54 THEN 4 END) DESC

Useful to copy directories from one server to another:

cd into the dir you want to have your data

scp -prq username@127.0.0.1:/var/www/comefromdir/ .

For example: Change Collation in a big database dump.

cat dumpname | sed s/CHARSET=utf8/CHARSET=utf8\ COLLATE=utf8_unicode_ci/ > neuer_dumpname

• Install imagemagick
• Create newdir and copy images to be resized into it
• cd into newdir

mogrify -format jpg -resize "800x500>" *

$ sed '/WORD1/,/WORD2/d' input.txt > output.txt

We were looking for a way to create mysqldumps which contained all the structures for the tables, but the data only for part of the tables.

nawk '/CREATE DATABASE \/\*\!32312 IF NOT EXISTS\*\/ \`%DB-NAME%\`/,$0 ~ /CREATE DATABASE/ && $0 !~ /%DB-NAME%/' DUMPFILE > DUMP_DB