Differences

This shows you the differences between two versions of the page.

--- onny:notizen [2026/09/17 13:07] – [fd] 10.250.0.1
+++ onny:notizen [2026/10/13 11:49] (current) – [nixos] 2001:7c0:200:300:b:5000:0:2ff
@@ Line 1131: / Line 1131: @@
 nix-update stamp --version=branch=main
 nix-update --use-update-script python3Packages.django-filingcabinet
+</code>
+run dynamically linked app
+<code bash>
+NIXPKGS_ALLOW_UNFREE=1 nix run --impure nixpkgs#steam-run -- ./pdfcraft
 </code>
 ==== configuration ====
@@ Line 2073: / Line 2079: @@
 </code>
-===== mariadb =====
+===== mariadb (mysql) =====
 import dump
 <code bash>
-mariadb -u root nextcloud < mydump.sql
+mycli -u root nextcloud < mydump.sql
 </code>
@@ Line 2091: / Line 2097: @@
 </code>
+enable logging
+<code sql>
+SET GLOBAL general_log = 0;
+SET GLOBAL log_output = 'FILE';
+SET GLOBAL general_log_file = '/var/lib/mysql/general.log';
+SET GLOBAL general_log = 1;
+</code>
+<code bash>
+ls -l /tmp/systemd-private-*-mysql.service-*/tmp/mariadb-general.log
+</code>
 ===== postgresql =====
@@ Line 2183: / Line 2200: @@
 <code>
 Ctrl-w v
+</code>
+update or reload current buffer
+<code>
+:reload
 </code>
 ===== traceroute =====
@@ Line 2280: / Line 2302: @@
 <code bash>
 zcat /proc/config.gz | rg CONFIG_RUST
+</code>
+===== fd =====
+search for all files with specific extension in directory /
+<code bash>
+fd --type f -e fm . /
+</code>
+zip all files with specific file extension
+<code bash>
+fd -t f -e fm . / | zip source -@
+</code>
+file creation timespan
+<code bash>
+fd --type f -e pdf --change-newer-than "2020-09-09" --changed-before "2020-10-01" .
+</code>
+execute command
+<code bash>
+fd --type f -e doc -e docx -e pdf -i gabriel -x cp --backup=t {} /tmp/gabriel/
+</code>
+find filenames unallowed characters
+<code bash>
+fd '[^A-Z a-züö@0-9._-]' remote/200_Archiv/CP_Dont_Touch
+</code>
+remove empty dirs in dir "data"
+<code bash>
+fd --type empty --type directory . /path/to/specific/dir -X rmdir
 </code>