Differences

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

--- servers:linux:nginx:piwigo [2025/08/27 19:59] – Sean Rhone
+++ servers:linux:nginx:piwigo [2025/08/27 20:15] (current) – Sean Rhone
@@ Line 14: / Line 14: @@
   * [[linux:distros:server:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]
-  * [[servers:linux:mariadb|MariaDB]]
   * [[servers:linux:nginx_php_php-fpm|nginx + PHP + PHP-FPM]]
   * [[servers;linux;nginx;lets_encrypt|Certbot (Let's Encrypt)]]
+  * [[servers:linux:mariadb|MariaDB]]
 ====== Dependencies ======
@@ Line 346: / Line 346: @@
 WantedBy=timers.target</code>
-====== Backup ======
+====== Old Restore ======
-===== Client =====
-==== Transfer Files To Client ====
-****
-  scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads' && sync
-====== Restore ======
 ===== Client =====
@@ Line 366: / Line 356: @@
   gunzip ~/'Downloads/piwigo-database-'*'.sql.gz'
-==== Transfer Files To Server ====
+====== Files ======
+===== Backup =====
 ****
-  scp ~/'Downloads/piwigo-files-'*'.tar.gz' ~/'Downloads/piwigo'*'.sql' espionage724@192.168.1.152:~
+  sudo tar -czf ~/'piwigo-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/srv/www' 'media'
-====== Files TODO ======
+===== scp =====
-===== Backup =====
+==== To Client Backup ====
-****
+  * Server back-up -> Client
+  * Run on server
-  sudo tar -czf ~/'piwigo-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/srv/www' 'media'
+  scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' ~/'Downloads'
-==== Old ====
+==== To Server Restore ====
-  * TODO: Uses an auth file; can use mariadb with user/pass flags instead of sudo
+  * Client -> (files) -> Server
+  * Run on client
-  sudo mariadb-dump --defaults-extra-file='/var/lib/mysql/auth/piwigo' --single-transaction 'piwigo' -r ~/'piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'
+  scp ~/'Downloads/piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~
 ===== Restore =====
@@ Line 398: / Line 392: @@
   rm -fv ~/'piwigo-files-'*'.tar.gz'
-====== Database TODO ======
+====== Database ======
 ===== Backup =====
@@ Line 405: / Line 399: @@
   sudo mariadb-dump --single-transaction --quick 'piwigo' -r ~/'piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'
+===== scp =====
+==== To Client Backup ====
+  * Server back-up -> Client
+  * Run on server
+  scp espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads'
+==== To Server Restore ====
+  * Client -> (files) -> Server
+  * Run on client
+  scp ~/'Downloads/piwigo'*'.sql' espionage724@192.168.1.152:~
 ===== Restore =====