Differences

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

--- servers:bsd:nginx:wordpress [2026/01/09 06:50] – [Dependencies] Sean Rhone
+++ servers:bsd:nginx:wordpress [2026/01/15 03:41] (current) – [Database] Sean Rhone
@@ Line 19: / Line 19: @@
   su -
-  pkg install git-lite php85-mysqli php85-intl php85-mbstring php85-xml php85-curl php85-dom php85-zlib php85-sodium php85-fileinfo
+  pkg install git-lite php85-mysqli php85-intl php85-mbstring php85-xml php85-curl php85-dom php85-zlib php85-sodium php85-fileinfo php85-zip php85-iconv
 ====== Download Source ======
@@ Line 68: / Line 68: @@
 ; Logging
-php_value[log_errors] = "0"
+php_value[log_errors] = "Off"
 php_value[error_reporting] = "~E_ALL"
+php_value[display_errors] = "Off"
+php_value[display_startup_errors] = "Off"
+php_value[html_errors] = "Off"
 ; General
 php_value[date.timezone] = "America/New_York"
+; WordPress
+php_value[post_max_size] = "10M"
+php_value[upload_max_filesize] = "10M"
 ; End</code>
@@ Line 147: / Line 154: @@
   su -
-  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'"
+  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" && clear
 <code>
@@ Line 186: / Line 193: @@
 '/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' reset --hard 'origin/master'"
 '/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' pull 'origin' 'master' --rebase"
+'/bin/sync'
 # End</code>
   su 'root' -c ~/'.local/scripts/www/blog/updater.sh'
+===== Backup =====
+  mkdir -p ~/'backups' ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/backup.sh' && chmod +x ~/'.local/scripts/www/blog/backup.sh'
+<code>
+#!/bin/sh
+cd '/tmp'
+'/usr/bin/tar' -czf '/home/espionage724/backups/wordpress-files-auto-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'blog'
+'/usr/local/bin/mariadb-dump' --single-transaction --quick 'wordpress' -r '/home/espionage724/backups/wordpress-database-auto-'$(date +%Y-%m-%d)'.sql'
+'/bin/sync'
+# End</code>
+  su 'root' -c ~/'.local/scripts/www/blog/backup.sh'
 ===== Maintenance =====
@@ Line 198: / Line 226: @@
 #!/bin/sh
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' gc --aggressive --prune='all'"
+cd '/tmp'
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' fsck --full --strict"
-'/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'wordpress'
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' gc --aggressive --prune='all'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' fsck --full --strict"
 # End</code>
-  ~/'.local/scripts/www/blog/maintenance.sh'
   su 'root' -c ~/'.local/scripts/www/blog/maintenance.sh'
@@ Line 212: / Line 238: @@
   * :!: Set email for ''user.email''
-  * :!: [[#initial_setup|Initial set-up]] needs re-completed for database connection ((re-use existing details))
   mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/git-fix.sh' && chmod +x ~/'.local/scripts/www/blog/git-fix.sh'
@@ Line 261: / Line 286: @@
 # End</code>
-  ~/'.local/scripts/www/blog/git-fix.sh'
   su 'root' -c ~/'.local/scripts/www/blog/git-fix.sh'
@@ Line 270: / Line 293: @@
 ===== Updater =====
-  * 02:00AM Every day
+  * Daily ''02:00:00 AM''
   su -
@@ Line 281: / Line 304: @@
 2 * * * root '/home/espionage724/.local/scripts/www/blog/updater.sh'
+# End</code>
+===== Backup =====
+  * Monthly (3rd) ''02:10:00 AM''
+  su -
+  ee '/etc/cron.d/blog-backup'
+<code>
+#
+SHELL=/bin/sh
+2 3 * * root '/home/espionage724/.local/scripts/www/blog/backup.sh'
+# End</code>
+===== Maintenance =====
+  * Monthly (3rd) ''02:30:00 AM''
+  su -
+  ee '/etc/cron.d/blog-maintenance'
+<code>
+#
+SHELL=/bin/sh
+2 3 * * root '/home/espionage724/.local/scripts/www/blog/maintenance.sh'
 # End</code>
@@ Line 294: / Line 349: @@
 ===== Database =====
-****
+  su -
-  mariadb-dump -u root -p --single-transaction --quick 'wordpress' -r '/home/espionage724/wordpress-database-manual-'$(date +%Y-%m-%d)'.sql'
+  mariadb-dump --single-transaction --quick 'wordpress' -r '/home/espionage724/wordpress-database-manual-'$(date +%Y-%m-%d)'.sql'
 ===== scp =====
@@ Line 314: / Line 369: @@
 ===== Folder =====
-  su -
+  su
-  rm -Rf '/usr/local/www/blog'
+  ls '/home/'$USER'/wordpress-files-'*'.tar.gz' && rm -Rf '/usr/local/www/blog'
-  tar -xzf '/home/espionage724/wordpress-files-'*'.tar.gz' -C '/usr/local/www' 'blog' && chown -R 'www':'www' '/usr/local/www/blog' && sync
+  tar -xzf '/home/'$USER'/wordpress-files-'*'.tar.gz' -C '/usr/local/www' 'blog' && chown -R 'www':'www' '/usr/local/www/blog' && sync
 ===== Database =====
@@ Line 334: / Line 389: @@
   su -
-  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'"
+  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" && clear
-  define( 'DB_HOST', 'localhost' );
   define( 'DB_HOST', '127.0.0.1' );