Replace barlin and burlin with berlin in db_2021.sql:

sed -i -E "s/([a-z0-9_\-]+)\.(barlin|burlin)/\1.berlin/g" db_2021.sql

Trim all array elements with PHP:

$trimmed_array = array_map('trim', $fruits);

To see the difference:

WGET do:

1. Download example.com
2. Download all level-1 and level-2 links
3. Download everything to : /root/t3mp/wget
4. Identify as 'Mozilla/MyUserAgent'
5. Ignore robots.txt
6. Random wait between requests (average : 3 seconds)

wget -U 'Mozilla/MyUserAgent' -P /root/t3mp/wget --wait=3 --random-wait -nd -r -l 2 -e robots=off https://example.com

Mysql export kann sehr lange dauert, wenn man viele und große Datenbanken hat. Damit man schnell ein Backup von allen DBs erstellen kann:

mysqldump --opt --quick --all-databases > /root/backup/mysql/alldbs.sql
  
  

Wenn User login notwendig ist :

mysqldump -u root -p --opt --quick --all-databases > /root/backup/mysql/alldbs.sql

1. Firefox
2. Chrome
3. Opera
4. Vivaldi
5. PDF Reader
6. Winrar
7. Docker
8. PhpStorm
9. OpenOffice
10. 1Password
11. Box
12. Cloud Software
13. FileZilla FTP Client
14. Eraser
15. Foldersize
16. MS Office
17. Node.js
18. Postman
19. Python
20. Skype
21. Smart Switch
22. VeraCrypt / TrueCrypt
23. Keepass
24. Teamviewer
25. WAMP Server / XAMPP
26. PowerShell
27. Ubuntu for Windows

While (endless, stop: CTRL+C)

while : 
 do 
  date
  echo "Hello "
  sleep 5
 done

Alternativ:

while : ; do date; echo "Hello "; sleep 6; done

Search for BERLIN in a very big file

cat very-big-bigfile.txt | grep -o -P '.{0,33}BERLIN.{0,44}'

1 * * * * wget -O /dev/null -o /dev/null my-example-website.com

1. Search / Grep  content of files in all-documents/
2. Move files containing africa to documents-africa/

grep -siRlI 'africa' all-documents/ | xargs mv -t documents-africa/

tar --exclude='./dir2ignore' --exclude='./cache_etc' -zcvf /backup/myarchive.tar.gz .