breakpo

  mysqld.cnf datadir = /new/data/dir mysqld --user=mysql --initialize innodb_flush_log_at_trx_commit= 0 ssl=0 #  (5.7 community (self built) might not use SSL for cases. 8.0 always use ssl by default, might be slower) innodb_doublewrite_pages=120 # (if doublewrite enabled for recent 8.0.x "on HDD") innodb_undo_log_truncate=OFF innodb_log_writer_threads=OFF   plugin-load-add=auth_socket.so auth_socket=FORCE_PLUS_PERMANENT   sudo systemctl stop apparmor sudo systemctl disable apparmor sudo mysqldump --master-data=1 --flush-logs --single-transaction --routines --quick --all-databases > db20230116_1852.sql CREATE USER 'XXXXX'@'%' IDENTIFIED WITH mysql_native_password BY 'XXXXXX'; GRANT ALL PRIVILEGES ON *.* TO 'XXXXX'@'%' WITH GRANT OPTION; FLUSH PRIVILIGES;  

 use  mysql  --ssl-mode=DISABLED   -p

How to enable php error logging with caddy and php-fpm Inside the file: pool.d/www.conf Edit at the end: php_admin_value[error_log] = /var/log/fpm-php.www.log php_admin_flag[log_errors] = on catch_workers_output = yes

#!/bin/bash # # Run this script on a file named urls.txt with all your URLs and pipe the output to an HTML file. # Example: ./convert_url_file.sh > bookmarks.html echo "<!DOCTYPE NETSCAPE-Bookmark-file-1>" echo '<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">' echo '<TITLE>Bookmarks</TITLE>' echo '<H1>Bookmarks</H1>' echo '<DL><p>'   cat urls.txt |   while read L; do     echo -n '    <DT><A HREF="';         echo ''"$L"'">'"$L"'</A>';   done echo "</DL><p>"    

sudo apt install squid sudo cp /etc/squid/squid.conf /etc/squid/squid.conf.original sudo chmod a-w /etc/squid/squid.conf.original sudo nano /etc/squid/squid.conf   inside squid.conf http_port XXXXX http_access allow all sudo update-rc.d squid disable sudo systemctl restart squid.service sudo systemctl status squid sudo systemctl disable squid sudo systemctl stop squid  

 rsync -avW -LK --progress ./from /to   this is even better: rsync -avhPW -LK --ignore-existing --size-only /source/ /media/dest/    

 sudo snap connect mysql-workbench-community:password-manager-service :password-manager-service