Differences

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

--- servers:windows:nginx:mybb [2026/01/20 11:33] – [Database] Sean Rhone
+++ servers:windows:nginx:mybb [2026/04/15 10:06] (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 mybb;
@@ Line 40: / Line 40: @@
 ===== PHP =====
-  "notepad.exe" "%SystemDrive%\www\php\forum.ini"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\php\forum.ini"
 <code>
@@ Line 64: / Line 64: @@
 ===== PHP-CGI =====
-  "notepad.exe" "%SystemDrive%\www\nginx\default.d\forum.conf"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\nginx\default.d\forum.conf"
 <code>
@@ Line 83: / Line 83: @@
 ===== Server Block =====
-  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\forum.conf"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\forum.conf"
 <code>
@@ Line 136: / Line 136: @@
   MKDIR "%SystemDrive%\www\scripts\forum"
-  "explorer.exe" "%SystemDrive%\www\scripts\forum"
+  "%SystemRoot%\explorer.exe" "%SystemDrive%\www\scripts\forum"
 ===== PHP-CGI =====
-  "notepad.exe" "%SystemDrive%\www\scripts\forum\PHP-CGI.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\forum\PHP-CGI.bat"
 <code>
@@ Line 150: / Line 150: @@
 SET "PHP_FCGI_CHILDREN=1"
-START "Forum PHP-CGI" /MIN "php-cgi.exe" -b "127.0.0.1:9006" -c "%SystemDrive%\www\php\forum.ini" -q
+START "Forum PHP-CGI" /MIN /D "%Temp%" "php-cgi.exe" -b "127.0.0.1:9006" -c "%SystemDrive%\www\php\forum.ini" -q
 SET "PHP_FCGI_MAX_REQUESTS="
@@ Line 161: / Line 161: @@
 ===== Update =====
-  "notepad.exe" "%SystemDrive%\www\scripts\forum\Update.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\forum\Update.bat"
 <code>
@@ Line 178: / Line 178: @@
 ===== Back-up =====
-  "notepad.exe" "%SystemDrive%\www\scripts\forum\Back-up.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\forum\Back-up.bat"
 <code>
@@ Line 186: / Line 186: @@
 CD "%Temp%"
-"tar.exe" -czf "D:\Servers\Scheduled Backups\mybb-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "forum"
+"%SystemRoot%\System32\tar.exe" -czf "D:\Servers\Scheduled Backups\mybb-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "forum"
-"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "D:\Servers\Scheduled Backups\%RANDOM%-mybb.sql" "mybb"
+"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "D:\Servers\Scheduled Backups\%RANDOM%-mybb.sql" "mybb"
-::"tar.exe" -czf "%UserProfile%\Downloads\mybb-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "forum"
+::"%SystemRoot%\System32\tar.exe" -czf "%UserProfile%\Downloads\mybb-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "forum"
-::"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "%UserProfile%\Downloads\%RANDOM%-mybb.sql" "mybb"
+::"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-mybb.sql" "mybb"
 :: End</code>
@@ Line 198: / Line 198: @@
 ===== Maintenance =====
-  "notepad.exe" "%SystemDrive%\www\scripts\forum\Maintenance.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\forum\Maintenance.bat"
 <code>
@@ Line 215: / Line 215: @@
 ===== Git Fix =====
-  * :!: Set email for ''user.email''
+  * :!: Set ''user.email''
-  "notepad.exe" "%SystemDrive%\www\scripts\forum\Git Fix.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\forum\Git Fix.bat"
 <code>
@@ Line 256: / Line 256: @@
   * Auto-start
-  SCHTASKS /Create /SC "ONLOGON" /TN "Forum PHP-CGI" /TR "%SystemDrive%\www\scripts\forum\PHP-CGI.bat" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "ONLOGON" /TN "Forum PHP-CGI" /TR "%SystemDrive%\www\scripts\forum\PHP-CGI.bat" /F
 ===== Update =====
@@ Line 262: / Line 262: @@
   * Daily ''05:00:00 AM''
-  SCHTASKS /Create /SC "DAILY" /TN "Forum Update" /TR "%SystemDrive%\www\scripts\forum\Update.bat" /ST "05:00" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "DAILY" /TN "Forum Update" /TR "%SystemDrive%\www\scripts\forum\Update.bat" /ST "05:00" /F
 ===== Back-up =====
@@ Line 268: / Line 268: @@
   * Monthly (6th) ''05:10:00 AM''
-  SCHTASKS /Create /SC "MONTHLY" /D "6" /M "*" /TN "Forum Back-up" /TR "%SystemDrive%\www\scripts\forum\Back-up.bat" /ST "05:10" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "MONTHLY" /D "6" /M "*" /TN "Forum Back-up" /TR "%SystemDrive%\www\scripts\forum\Back-up.bat" /ST "05:10" /F
 ===== Maintenance =====
@@ Line 274: / Line 274: @@
   * Monthly (6th) ''05:30:00 AM''
-  SCHTASKS /Create /SC "MONTHLY" /D "6" /M "*" /TN "Forum Maintenance" /TR "%SystemDrive%\www\scripts\forum\Maintenance.bat" /ST "05:30" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "MONTHLY" /D "6" /M "*" /TN "Forum Maintenance" /TR "%SystemDrive%\www\scripts\forum\Maintenance.bat" /ST "05:30" /F
 ====== Initial Setup ======
@@ Line 301: / Line 301: @@
 ===== config.php =====
-****
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\forum\inc\config.php"
-  "notepad.exe" "%SystemDrive%\www\forum\inc\config.php"
+  $config['database']['hostname'] = 'localhost';
 ====== Backup ======
@@ Line 311: / Line 311: @@
 ****
-  "tar.exe" -czf "%UserProfile%\Downloads\mybb-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "forum"
+  "%SystemRoot%\System32\tar.exe" -czf "%UserProfile%\Downloads\mybb-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "forum"
 ===== Database =====
@@ Line 317: / Line 317: @@
 ****
-  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "mybb.sql" "mybb"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\mybb.sql" "mybb"
 ====== Restore ======
@@ Line 325: / Line 325: @@
   * [[#database|Initial set-up]]
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" --execute="CREATE DATABASE mybb"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --execute="CREATE DATABASE mybb"
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" "mybb" < "%UserProfile%\Downloads\mybb.sql"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" "mybb" < "%UserProfile%\Downloads\mybb.sql"