MYSQL neu starten:

 service mysql restart || service mariadb restart || service mysqld restart  

Description_of_the_Problem

 RedirectMatch 301 ^/index.php/(.*) /$1

Mit einem Befehl alle .JPG und .PNG Dateien finden:

find ./ -size +1024 -type f \( -iname \*.jpg -o -iname \*.png \) -exec du -sh {} \;

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:

$fruits = [' apple ', 'orange ', ' mango', 'kiwi' ];

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

echo " <pre>";
print_r( $trimmed_array );
print_r( $fruits );

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

For (5x):

for i in {1..5}
do
   echo "Number is $i "
   sleep 2
done

 Alternativ 1:

for i in {1..5}; do echo "Number is $i "; sleep 2; done

 Alternativ 2:

for i in {1..5}; do echo "Number is $i " && sleep 2; done

Search for BERLIN in a very big file

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