Differences

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

--- servers:windows:nginx:wordpress [2025/01/08 02:51] – Sean Rhone
+++ servers:windows:nginx:wordpress [2025/04/18 11:23] (current) – [PHP-CGI] Sean Rhone
@@ Line 7: / Line 7: @@
 ===== Prerequisites =====
-  * [[windows:10|Windows 10]]
+  * [[windows;11_ltsc|Windows 11 (24H2)]]
   * [[servers;windows;nginx_php_php-cgi|nginx + PHP + PHP-CGI]]
   * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]]
@@ Line 19: / Line 19: @@
   * https://www.git-scm.com/download/win
-  * Last tested: ''Git-2.47.0.2-64-bit.exe''
+  * Last tested: ''Git-2.48.1-64-bit.exe''
   * Git from the command line and also from 3rd-party software
@@ Line 26: / Line 26: @@
   * https://mariadb.org/download/
-  * Last tested: ''mariadb-11.6.2-winx64.msi''
+  * Last tested: ''mariadb-11.7.2-winx64.msi''
   * No Development components or Third party tools
@@ Line 36: / Line 36: @@
   * https://github.com/WordPress/WordPress/commits/master/
-  git clone --branch "master" --depth "1" --recurse-submodules "https://github.com/WordPress/WordPress.git" "%SystemDrive%\www\blog"
+  "%ProgramFiles%\Git\bin\git.exe" clone --branch "master" --depth "1" --recurse-submodules "https://github.com/WordPress/WordPress.git" "%SystemDrive%\www\blog"
-  explorer "%SystemDrive%\www\blog"
+  "explorer.exe" "%SystemDrive%\www\blog"
 ====== Database ======
-  "%ProgramFiles%\MariaDB 11.6\bin\mariadb.exe" -u "root" -p
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p
   CREATE DATABASE wordpress;
@@ Line 58: / Line 58: @@
 ===== PHP =====
-  notepad "%SystemDrive%\www\php\blog.ini"
+  "notepad.exe" "%SystemDrive%\www\php\blog.ini"
 <code>
@@ Line 76: / Line 76: @@
 ; Settings
+error_reporting = "E_ERROR"
+display_errors = "Off"
 [Date]
 date.timezone = "America/New_York"
@@ Line 81: / Line 84: @@
 ; End</code>
-  CD "%SystemDrive%\" && "php.exe" -c "%SystemDrive%\www\php\blog.ini" -m
+  "php.exe" -c "%SystemDrive%\www\php\blog.ini" -m
 ====== nginx + PHP-CGI Configuration ======
@@ Line 87: / Line 90: @@
 ===== PHP-CGI =====
-  * :!: ''fastcgi_params'' include hard-coded to nginx version path
+  "notepad.exe" "%SystemDrive%\www\nginx\default.d\blog.conf"
-  notepad "%SystemDrive%\www\nginx\default.d\blog.conf"
 <code>
@@ Line 97: / Line 98: @@
     fastcgi_intercept_errors "on";
     fastcgi_index "index.php";
-    include "C:/nginx-1.27.3/conf/fastcgi_params";
+    include "C:/www/nginx/conf/fastcgi_params";
     fastcgi_param "SCRIPT_FILENAME" $document_root$fastcgi_script_name;
     fastcgi_param "PATH_INFO" $fastcgi_path_info;
     fastcgi_param "HTTPS" "on";
     fastcgi_pass "127.0.0.1:9004";
-}</code>
+}
+# End</code>
 ===== Server Block =====
-  notepad "%SystemDrive%\www\nginx\vhosts.d\blog.conf"
+  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\blog.conf"
 <code>
@@ Line 135: / Line 138: @@
           access_log off; log_not_found off; expires max;
     }
-}</code>
+}
-  "%SystemDrive%\www\scripts\nginx Reload.bat"
+# End</code>
-====== Batch Files ======
+  "%SystemDrive%\www\scripts\nginx\Reload.bat"
+====== Scripts ======
   MKDIR "%SystemDrive%\www\scripts\blog"
-  explorer "%SystemDrive%\www\scripts\blog"
+  "explorer.exe" "%SystemDrive%\www\scripts\blog"
 ===== PHP-CGI =====
-  notepad "%SystemDrive%\www\scripts\blog\PHP-CGI.bat"
+  "notepad.exe" "%SystemDrive%\www\scripts\blog\PHP-CGI.bat"
 <code>
@@ Line 158: / Line 163: @@
   "%SystemDrive%\www\scripts\blog\PHP-CGI.bat"
-==== Autostart ====
-  explorer "%ProgramData%\Microsoft\Windows\Start Menu\Programs\StartUp"
-  "%SystemDrive%\www\scripts\blog\PHP-CGI.bat"
-  Blog PHP-CGI
 ===== Update =====
@@ Line 171: / Line 168: @@
   * https://github.com/WordPress/WordPress/commits/master/
-  notepad "%SystemDrive%\www\scripts\blog\Update.bat"
+  "notepad.exe" "%SystemDrive%\www\scripts\blog\Update.bat"
 <code>
 @echo off
-"git.exe" -C "%SystemDrive%\www\blog" reset --hard
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" reset --hard
-"git.exe" -C "%SystemDrive%\www\blog" pull origin "master" --rebase
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" pull origin "master" --rebase
-pause
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" gc --aggressive --prune="all"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" fsck --full --strict
 :: End</code>
@@ Line 185: / Line 183: @@
   "%SystemDrive%\www\scripts\blog\Update.bat"
-===== Maintenance =====
+====== Shortcuts ======
-  notepad "%SystemDrive%\www\scripts\blog\Maintenance.bat"
+===== Desktop =====
-<code>
+  "%SystemDrive%\www\scripts\blog\Update.bat"
-@echo off
-"git.exe" -C "%SystemDrive%\www\blog" gc --aggressive --prune="all"
+  Blog Update
-"git.exe" -C "%SystemDrive%\www\blog" fsck --full --strict
-pause
+===== Autostart =====
-:: End</code>
+  "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\StartUp"
-  "%SystemDrive%\www\scripts\blog\Maintenance.bat"
+  "%SystemDrive%\www\scripts\blog\PHP-CGI.bat"
+  Blog PHP-CGI
 ====== Initial Setup ======
@@ Line 208: / Line 206: @@
   * https://developer.wordpress.org/advanced-administration/wordpress/update-services/#xml-rpc-ping-services
+===== wp-config.php =====
+  * Add around line 90 ((convenient ''Add any custom values between this line and the "stop editing" line.''))
+  "notepad.exe" "%SystemDrive%\www\blog\wp-config.php"
+<code>define( 'WP_AUTO_UPDATE_CORE', false );</code>
+====== Database ======
+===== Backup =====
+  CD "%UserProfile%\Downloads"
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb-dump.exe" -u "root" -p --opt -r "wordpress.sql" "wordpress"
+===== Restore =====
+  * [[#database|Initial set-up]]
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p "wordpress" < "%UserProfile%\Downloads\wordpress.sql"
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="GRANT ALL PRIVILEGES ON wordpress.* to 'wordpress'@'localhost';"
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="DROP DATABASE wordpress"
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE wordpress"