LOAD DATA LOCAL INFILEINTO TABLE FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' IGNORE 1 LINES (
, , ...) ;
Graphic
ImageMagick
quick dirty autoconvert raw images
ls *.CR2 | while read i;do dcraw -w -q 3 -c $i | convert -colorspace HSL -channel Saturation -negate -evaluate multiply 0.95 -negate -colorspace sRGB -gamma 1.1 -normalize -unsharp 0.5x0.5+0.5+0.008 -blur 1x1 - "`basename $i .CR2`b.jpg";done
Merge convert multiple jpg's files into one pdf
tnx 2 dlemstra
convert [-density 300] -define pdf:fit-page=A4 *.jpg out.pdf
Merge convert multiple PDF files into one PDF
tnx 2 alcohol
pdftk file1.pdf file2.pdf cat output target.pdf
Audio
rip audio cdrom to mp3 with abcde
tnx 2 andrew.46
zypper install python-eyeD3 abcde lame imagemagick cdparanoia glyrc abcde -o mp3:-V2 -a default,getalbumart for i in *.mp3; do eyeD3 --add-image cover.jpg:FRONT_COVER "$i" done