Differences

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

--- debian_common [2024/03/19 11:25] – [Watchlist for backup] Júne Park
+++ debian_common [2024/04/18 07:49] – [Major LTS upgrade] Júne Park
@@ Line 40: / Line 40: @@
 /opt/scripts/
 </code>
-**MariaDB** ''per DATABASE''
-=== Backup MariaDB DATABASE ===
-<code bash>
-/usr/bin/mysqldump --single-transaction -h localhost -u root -p[database_passwd] [database_name] > /..(path)../.backup/[database_name]-sqlbkp_`date +"%Y%m%d"`.bak
-</code>
 **update-motd**
@@ Line 59: / Line 53: @@
 </code>
+**MariaDB** ''per DATABASE''
+=== Backup MariaDB DATABASE ===
+<code bash>
+/usr/bin/mysqldump --single-transaction -h localhost -u root -p[database_passwd] [database_name] > /..(path)../.backup/[database_name]-sqlbkp_`date +"%Y%m%d"`.bak
+</code>
 ----
-----
 === Backup using rsync command ===
@@ Line 76: / Line 75: @@
 ----
+=== Remote backup for webpages ===
+Rsync with ''[TARGET]'' using rsync from ''[SOURCE]''
+<code bash>
+sudo -u www-data rsync -azP --exclude '.ssh' -e 'ssh -p [port_number]' --rsync-path="sudo rsync" /var/www/ [user]@[TARGET]:"/[TARGET PATH]../../"
+</code>
+Put ''[SOURCE]'' public key in ''[TARGET]'' user's ''authorized_keys''
+----
 ==== Configure log files ====
@@ Line 95: / Line 101: @@
 ----
+==== Set hostnames ====
+<code bash>
+sudo hostname HOSTiD
+sudo hostnamectl HOSTiD
+</code>
+Edit ''/etc/hostname'' with full domain name
+<code bash>
+hostid.mydomain.com
+</code>
+----
 ==== Enable SSH ====
@@ Line 500: / Line 520: @@
 ----
+===== Install Services =====
+==== Nextcloud™ ====
+[[os_nextcloud|Nextcloud 101]] --- Nextcloud user's Guides
+----
 ===== Upgrade & Maintenance =====