Differences

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

--- debian_common [2024/02/02 09:56] – [Watchlist for backup] Júne Park
+++ debian_common [2024/04/18 07:49] – [Major LTS upgrade] Júne Park
@@ Line 34: / Line 34: @@
 ==== Watchlist for backup ====
-<code>
+<code bash>
 /etc/nginx/sites-available/*
 /var/www/*
+/etc/transmission-daemon/
+/opt/scripts/
+</code>
+**update-motd**
+<code bash>
+/etc/update-motd.d/
 </code>
+**crontab**
+<code bash>
+sudo crontab -l
+sudo -u www-data crontab -l
+crontab -l
+</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 ===
+== Backup Nginx configuration files ==
+<code bash>
+sudo rsync -avh --progress /etc/nginx/sites-available/ /home/meson/.backup/nginx/nginx_config_`date +"%Y%m"`/
+</code>
+== Backup HTML source files ==
+<code bash>
+sudo rsync -avh --progress /var/www/ /home/meson/.backup/html/html_backup_`date +"%Y%m"`/
+</code>
+----
+=== 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 ====
+Edit ''/etc/nginx/nginx.conf''
+<code nginx>
+        access_log /var/log/nginx/_access.log;
+        error_log /var/log/nginx/_error.log;
+</code>
+----
+==== Purge log files ====
+== Cleaning compressed log files ==
+<code bash>
+sudo find /var/log -name '*.gz' -exec rm {} \;
+</code>
+----
+==== Set hostnames ====
+<code bash>
+sudo hostname HOSTiD
+sudo hostnamectl HOSTiD
+</code>
+Edit ''/etc/hostname'' with full domain name
+<code bash>
+hostid.mydomain.com
+</code>
 ----
@@ Line 86: / Line 160: @@
 </code>
+=== Time stamp prompt ===
+Edit ''~/.bashrc'' and change ''PS1'' line
+<code bash>
+if [ "$color_prompt" = yes ]; then
+    PS1='${debian_chroot:+($debian_chroot)}\[\033[01;32m\]\u@\h\[\033[00m\]: \[\033[01;33m\]\D{%T}\[\033[00m\] \[\033[01;37m\]\w\$\[\033[00m\] '
+else
+    PS1='${debian_chroot:+($debian_chroot)}\u@\h: \D{%T} \w\$ '
+fi
+</code>
+Save and load ''.bashrc''
+<code bash>
+source ~/.bashrc
+</code>
 ----
@@ Line 428: / Line 520: @@
 ----
+===== Install Services =====
+==== Nextcloud™ ====
+[[os_nextcloud|Nextcloud 101]] --- Nextcloud user's Guides
+----
 ===== Upgrade & Maintenance =====