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 revisionBoth sides next revision
debian_common [2024/03/13 06:44] โ€“ [Watchlist for backup] Jรบne Parkdebian_common [2024/03/19 11:25] โ€“ [Watchlist for backup] Jรบne Park
Line 41: Line 41:
 </code> </code>
 **MariaDB** ''per DATABASE'' **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** 
 <code bash> <code bash>
Line 46: Line 52:
 </code> </code>
  
-=== Backup MariaDB DATABASE === ย +**crontab** 
 <code bash>  <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ย +sudo crontab -l ย 
-</code> +sudo -u www-data crontab -l ย 
 +crontab -l ย 
 +</code>ย 
  
 ----  ---- 
  • debian_common
  • Last modified: 2024/04/18 08:58
  • by Jรบne Park