RoE | Wiki

User Tools

Site Tools

Trace: • opensuse_tumbleweed_kde • fedora_kde • dota_2_classic_source1_steamcmd • mariadb • grav • status_page
servers:linux:mariadb

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
servers:linux:mariadb [2025/09/11 07:33] – Sean Rhoneservers:linux:mariadb [2026/01/01 03:22] (current) – Ubuntu -> oS TW Sean Rhone
Line 64: Line 64:
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
  
-  FLUSH PRIVILEGES; +  FLUSH PRIVILEGES;EXIT;
- +
-  EXIT+
  
 ==== Authentication File ==== ==== Authentication File ====
Line 88: Line 86:
 Group=mysql Group=mysql
 Type=oneshot Type=oneshot
 +
 +WorkingDirectory=/var/lib/mysql
  
 ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair
Line 97: Line 97:
 ==== Timer ==== ==== Timer ====
  
-  * Weekly+  * Weekly (Sunday) ''07:10:00 AM''
  
   sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now   sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now
Line 107: Line 107:
  
 [Timer] [Timer]
-OnCalendar=weekly+OnCalendar=Sun *-*-* 07:10:00
 Persistent=true Persistent=true
  
/usr/local/www/wiki/data/attic/servers/linux/mariadb.1757590383.txt.gz · Last modified: by Sean Rhone