| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:windows:nginx:piwigo [2026/03/11 15:11] – Sean Rhone | servers:windows:nginx:piwigo [2026/04/15 10:05] (current) – [PHP-CGI] Sean Rhone |
|---|
| |
| * [[windows;10_ltsc_server|Windows 10 (21H2)]] | * [[windows;10_ltsc_server|Windows 10 (21H2)]] |
| * [[servers;windows;freenginx_php_php-cgi|freenginx + PHP + PHP-CGI]] | * [[servers;windows;nginx_php_php-cgi|nginx + PHP + PHP-CGI]] |
| * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]] | * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]] |
| * [[programs;windows;git|Git]] | * [[programs;windows;git|Git]] |
| SET "PHP_FCGI_CHILDREN=1" | 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=" | SET "PHP_FCGI_MAX_REQUESTS=" |
| |
| "%SystemRoot%\System32\tar.exe" -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media" | "%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" | ::"%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> | :: End</code> |
| **** | **** |
| |
| 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 ====== | ====== Restore ====== |
| ===== Albums Formatting ===== | ===== 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 ==== | ==== 4 Links ==== |
