Differences

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

--- servers:windows:nginx:piwigo [2025/06/03 00:33] – Sean Rhone
+++ servers:windows:nginx:piwigo [2025/06/14 21:10] (current) – [Prerequisites] Sean Rhone
@@ Line 11: / Line 11: @@
   * [[servers;windows;nginx_php_php-cgi|nginx + PHP + PHP-CGI]]
   * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]]
+  * [[programs;windows;git|Git]]
+  * [[servers;windows;mariadb|MariaDB]]
 ===== TODOs =====
   * Show title on pictures (long titles get cut-off in navbar)
-  * AI ([[https://piwigo.org/forum/viewtopic.php?pid=192438#p192438|post]])
+  * AI ([[https://piwigo.org/forum/viewtopic.php?pid=192438#p192438|post]], [[https://github.com/Piwigo/Piwigo/commits/master/include/config_default.inc.php|config.inc.php]])
 ====== Dependencies ======
   * https://piwigo.org/guides/install/requirements
-===== Git =====
-  * https://git-scm.com/downloads/win
-  * Last tested: ''Git-2.49.0-64-bit.exe''
-===== MariaDB Server =====
-  * https://mariadb.org/download/
-  * Last tested: ''mariadb-11.8.1-winx64.msi''
-  * No Development components or Third party tools
-  * Use UTF8 as default server's character set
 ====== Download Source ======
@@ Line 48: / Line 37: @@
 ====== Database ======
-  "%ProgramFiles%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p
+  "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p
   CREATE DATABASE piwigo;
@@ Line 177: / Line 166: @@
 ===== Update =====
-  * https://github.com/Piwigo/Piwigo/commits/master/
-  * https://github.com/Piwigo/piwigo-bootstrap-darkroom/commits/master/
   "notepad.exe" "%SystemDrive%\www\scripts\media\Update.bat"
@@ Line 217: / Line 203: @@
 ==== CGI ====
-  * TODO: Task Scheduler
   "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\StartUp"
@@ Line 320: / Line 304: @@
   "tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-==== FreeBSD ====
-****
-  "%USERPROFILE%\Downloads\OpenSSH-Win64\scp.exe" "%USERPROFILE%\Downloads\piwigo-files-manual-"*".tar.gz" "%USERPROFILE%\Downloads\piwigo.sql" espionage724@192.168.1.152:~
 ====== Database ======
@@ Line 331: / Line 309: @@
 ===== Backup =====
-  CD "%UserProfile%\Downloads"
+****
-  "%ProgramFiles%\MariaDB 11.8\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo.sql" "piwigo"
+  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo.sql" "piwigo"
 ===== Restore =====
@@ Line 339: / Line 317: @@
   * [[#database|Initial set-up]]
-  "%ProgramFiles%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE piwigo"
+  "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE piwigo"
-  "%ProgramFiles%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
+  "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
 ====== Quick Commands ======