Differences

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

--- servers:windows:nginx:wordpress [2025/02/16 17:00] – Sean Rhone
+++ servers:windows:nginx:wordpress [2025/04/18 11:23] (current) – [PHP-CGI] Sean Rhone
@@ Line 7: / Line 7: @@
 ===== Prerequisites =====
-  * [[windows:11_ltsc|Windows 11]]
+  * [[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 89: / Line 89: @@
 ===== PHP-CGI =====
-  * :!: ''fastcgi_params'' include hard-coded to nginx version path
   "notepad.exe" "%SystemDrive%\www\nginx\default.d\blog.conf"
@@ Line 100: / Line 98: @@
     fastcgi_intercept_errors "on";
     fastcgi_index "index.php";
-    include "C:/nginx-1.27.4/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;
@@ Line 170: / 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>
@@ Line 213: / Line 211: @@
   * Add around line 90 ((convenient ''Add any custom values between this line and the "stop editing" line.''))
-  notepad "%SystemDrive%\www\blog\wp-config.php"
+  "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"