debian_common

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
Next revisionBoth sides next revision
debian_common [2024/03/19 11:25] – [Watchlist for backup] JΓΊne Parkdebian_common [2024/04/07 11:11] – [Purge log files] JΓΊne Park
Line 40: Line 40:
 /opt/scripts/  /opt/scripts/ 
 </code> </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**  **update-motd** 
Line 59: Line 53:
 </code> </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 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 ====  ==== 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 ====  ==== Enable SSH ==== 
  
  • debian_common
  • Last modified: 2024/04/18 08:58
  • by JΓΊne Park