Differences

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

--- servers:windows:nginx:wordpress [2026/01/20 11:10] – [Settings] Sean Rhone
+++ servers:windows:nginx:wordpress [2026/04/15 10:05] (current) – [PHP-CGI] Sean Rhone
@@ Line 26: / Line 26: @@
 ====== Database ======
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root"
   CREATE DATABASE wordpress;
@@ Line 40: / Line 40: @@
 ===== PHP =====
-  "notepad.exe" "%SystemDrive%\www\php\blog.ini"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\php\blog.ini"
 <code>
@@ Line 72: / Line 72: @@
 ===== PHP-CGI =====
-  "notepad.exe" "%SystemDrive%\www\nginx\default.d\blog.conf"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\nginx\default.d\blog.conf"
 <code>
@@ Line 94: / Line 94: @@
   * Deny all except ''twentytwentyfive''
-  "notepad.exe" "%SystemDrive%\www\nginx\default.d\wp-themes-deny.conf"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\nginx\default.d\wp-themes-deny.conf"
 <code>
@@ Line 105: / Line 105: @@
 ===== Server Block =====
-  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\blog.conf"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\blog.conf"
 <code>
@@ Line 137: / Line 137: @@
   MKDIR "%SystemDrive%\www\scripts\blog"
-  "explorer.exe" "%SystemDrive%\www\scripts\blog"
+  "%SystemRoot%\explorer.exe" "%SystemDrive%\www\scripts\blog"
 ===== PHP-CGI =====
-  "notepad.exe" "%SystemDrive%\www\scripts\blog\PHP-CGI.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\blog\PHP-CGI.bat"
 <code>
@@ Line 151: / Line 151: @@
 SET "PHP_FCGI_CHILDREN=1"
-START "Blog PHP-CGI" /MIN "php-cgi.exe" -b "127.0.0.1:9004" -c "%SystemDrive%\www\php\blog.ini" -q
+START "Blog PHP-CGI" /MIN /D "%Temp%" "php-cgi.exe" -b "127.0.0.1:9004" -c "%SystemDrive%\www\php\blog.ini" -q
 SET "PHP_FCGI_MAX_REQUESTS="
@@ Line 162: / Line 162: @@
 ===== Update =====
-  "notepad.exe" "%SystemDrive%\www\scripts\blog\Update.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\blog\Update.bat"
 <code>
@@ Line 179: / Line 179: @@
 ===== Back-up =====
-  "notepad.exe" "%SystemDrive%\www\scripts\blog\Back-up.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\blog\Back-up.bat"
 <code>
@@ Line 187: / Line 187: @@
 CD "%Temp%"
-"tar.exe" -czf "D:\Servers\Scheduled Backups\wordpress-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "blog"
+"%SystemRoot%\System32\tar.exe" -czf "D:\Servers\Scheduled Backups\wordpress-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "blog"
-"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "D:\Servers\Scheduled Backups\%RANDOM%-wordpress.sql" "wordpress"
+"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "D:\Servers\Scheduled Backups\%RANDOM%-wordpress.sql" "wordpress"
-::"tar.exe" -czf "%UserProfile%\Downloads\wordpress-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "blog"
+::"%SystemRoot%\System32\tar.exe" -czf "%UserProfile%\Downloads\wordpress-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "blog"
-::"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "%UserProfile%\Downloads\%RANDOM%-wordpress.sql" "wordpress"
+::"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-wordpress.sql" "wordpress"
 :: End</code>
@@ Line 199: / Line 199: @@
 ===== Maintenance =====
-  "notepad.exe" "%SystemDrive%\www\scripts\blog\Maintenance.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\blog\Maintenance.bat"
 <code>
@@ Line 216: / Line 216: @@
 ===== Git Fix =====
-  * :!: Set email for ''user.email''
+  * :!: Set ''user.email''
-  "notepad.exe" "%SystemDrive%\www\scripts\blog\Git Fix.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\blog\Git Fix.bat"
 <code>
@@ Line 273: / Line 273: @@
   * Auto-start
-  SCHTASKS /Create /SC "ONLOGON" /TN "Blog PHP-CGI" /TR "%SystemDrive%\www\scripts\blog\PHP-CGI.bat" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "ONLOGON" /TN "Blog PHP-CGI" /TR "%SystemDrive%\www\scripts\blog\PHP-CGI.bat" /F
 ===== Update =====
@@ Line 279: / Line 279: @@
   * Daily ''02:00:00 AM''
-  SCHTASKS /Create /SC "DAILY" /TN "Blog Update" /TR "%SystemDrive%\www\scripts\blog\Update.bat" /ST "02:00" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "DAILY" /TN "Blog Update" /TR "%SystemDrive%\www\scripts\blog\Update.bat" /ST "02:00" /F
 ===== Back-up =====
@@ Line 285: / Line 285: @@
   * Monthly (3rd) ''02:10:00 AM''
-  SCHTASKS /Create /SC "MONTHLY" /D "3" /M "*" /TN "Blog Back-up" /TR "%SystemDrive%\www\scripts\blog\Back-up.bat" /ST "02:10" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "MONTHLY" /D "3" /M "*" /TN "Blog Back-up" /TR "%SystemDrive%\www\scripts\blog\Back-up.bat" /ST "02:10" /F
 ===== Maintenance =====
@@ Line 291: / Line 291: @@
   * Monthly (3rd) ''02:30:00 AM''
-  SCHTASKS /Create /SC "MONTHLY" /D "3" /M "*" /TN "Blog Maintenance" /TR "%SystemDrive%\www\scripts\blog\Maintenance.bat" /ST "02:30" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "MONTHLY" /D "3" /M "*" /TN "Blog Maintenance" /TR "%SystemDrive%\www\scripts\blog\Maintenance.bat" /ST "02:30" /F
 ====== Initial Setup ======
@@ Line 311: / Line 311: @@
   * :!: Change ''DB_PASSWORD''
-  "notepad.exe" "%SystemDrive%\www\blog\wp-config.php"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\blog\wp-config.php"
 <code>
@@ Line 343: / Line 343: @@
 ****
-  "tar.exe" -czf "%UserProfile%\Downloads\wordpress-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "blog"
+  "%SystemRoot%\System32\tar.exe" -czf "%UserProfile%\Downloads\wordpress-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "blog"
 ===== Database =====
@@ Line 349: / Line 349: @@
 ****
-  CD "%USERPROFILE%\Downloads" && "%PROGRAMFILES%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "wordpress.sql" "wordpress"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\wordpress.sql" "wordpress"
 ====== Restore ======
@@ Line 357: / Line 357: @@
   * [[#database|Initial set-up]]
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" --execute="CREATE DATABASE wordpress"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --execute="CREATE DATABASE wordpress"
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" "wordpress" < "%UserProfile%\Downloads\wordpress.sql"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" "wordpress" < "%UserProfile%\Downloads\wordpress.sql"