LOAD DATA LOCAL INFILEINTO TABLE FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' IGNORE 1 LINES (
, , ...) ;
Joomla
Akeeba Backup
https://www.akeebabackup.com/download/akeeba-backup/akeeba-backup-3-3-11/com_akeeba-3311-corezip.raw admin login -> erweiterungen -> installieren -> com_akeeba-3.3.11-core.zip Komponenten -> Akeeba Backup -> Starte den Konfigurationsassistenten Komponenten -> Akeeba Backup -> start backup
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
Split PDF file
tnx 2
pdftk file.pdf cat [page(-page)] output target.pdf pdftk file.pdf cat [page( page ...)] output target.pdf