Differences

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

--- debian_common [2024/03/12 06:46] – [Watchlist for backup] Júne Park
+++ debian_common [2024/03/19 11:30] – [Watchlist for backup] Júne Park
@@ Line 36: / Line 36: @@
 <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 ==
@@ Line 50: / 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 ====
+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>
+----
 ==== Enable SSH ====
@@ Line 95: / Line 146: @@
 </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>
 ----