Differences

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

--- servers:windows:nginx:piwigo [2026/03/11 14:24] – [database.inc.php] Sean Rhone
+++ servers:windows:nginx:piwigo [2026/04/15 10:05] (current) – [PHP-CGI] Sean Rhone
@@ Line 150: / Line 150: @@
 SET "PHP_FCGI_CHILDREN=1"
-START "Media PHP-CGI" /MIN "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q
+START "Media PHP-CGI" /MIN /D "%Temp%" "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q
 SET "PHP_FCGI_MAX_REQUESTS="
@@ Line 190: / Line 190: @@
 "%SystemRoot%\System32\tar.exe" -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt -r "D:\Servers\Scheduled Backups\%RANDOM%-piwigo.sql" "piwigo"
+"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "D:\Servers\Scheduled Backups\%RANDOM%-piwigo.sql" "piwigo"
 ::"%SystemRoot%\System32\tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-::"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt -r "%UserProfile%\Downloads\%RANDOM%-piwigo.sql" "piwigo"
+::"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-piwigo.sql" "piwigo"
 :: End</code>
@@ Line 399: / Line 399: @@
 ****
-  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt -r "piwigo.sql" "piwigo"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\piwigo.sql" "piwigo"
 ====== Restore ======
@@ Line 415: / Line 415: @@
 ===== Albums Formatting =====
-  * :!: Using Emojis (like 8-) from [[https://emojipedia.org/smiling-face-with-sunglasses|Emojipedia]]) in comments causes MySQL exception
+  * :!: Using Emojis (like 8-) from [[https://emojipedia.org/smiling-face-with-sunglasses|Emojipedia]]) in comments caused a MySQL exception
 ==== 4 Links ====
@@ Line 432: / Line 432: @@
 <a href="https://wiki.realmofespionage.xyz/games;windows;dota_2_steamcmd" target="_blank" rel="noopener">Notes</a>
 </code>
-====== TODO ======
-  * Show title on pictures (long titles get cut-off in navbar)