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
debian_common [2024/03/19 11:25] – [Watchlist for backup] Júne Parkdebian_common [2024/03/19 11:30] (current) – [Watchlist for backup] 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 ==== 
  
  • debian_common
  • Last modified: 2024/03/19 11:30
  • by Júne Park