[chronojump-server] Added SQL backups

[Xavier Padullés <xpadulles src gnome org>]

commit 0d1249dc07bf3bda9e66d9d9f1ed5fd5d41f429a
Author: Xavier Padullés <x padulles gmail com>
Date:   Mon Jul 1 17:32:40 2019 +0200

    Added SQL backups

 backup-scripts/backup_sql-annually.sh | 3 +++
 backup-scripts/backup_sql-daily.sh    | 5 +++++
 backup-scripts/backup_sql-monthly.sh  | 5 +++++
 backup-scripts/backup_sql-weekly.sh   | 5 +++++
 4 files changed, 18 insertions(+)
---
diff --git a/backup-scripts/backup_sql-annually.sh b/backup-scripts/backup_sql-annually.sh
new file mode 100755
index 0000000..ee0c7e1
--- /dev/null
+++ b/backup-scripts/backup_sql-annually.sh
@@ -0,0 +1,3 @@
+#!/bin/bash
+mysqldump -u root --all-databases --add-drop-table --events --ignore-table=mysql.event |gzip > 
/home/rootcompujump/backup/annual/mysql_backup-`date +\%Y-\%m-\%d`.sql.gz
+
diff --git a/backup-scripts/backup_sql-daily.sh b/backup-scripts/backup_sql-daily.sh
new file mode 100755
index 0000000..fe9cfba
--- /dev/null
+++ b/backup-scripts/backup_sql-daily.sh
@@ -0,0 +1,5 @@
+#/bin/bash
+mysqldump -u root --all-databases --add-drop-table --events --ignore-table=mysql.event | gzip > 
/home/rootcompujump/backup/daily/mysql_backup-`date +\%Y-\%m-\%d`.sql.gz
+
+#Esborrar els backups més antics de 7 dies
+find /home/rootcompujump/backup/daily/ -mtime +8 -execdir rm "{}" "+"
diff --git a/backup-scripts/backup_sql-monthly.sh b/backup-scripts/backup_sql-monthly.sh
new file mode 100755
index 0000000..1e4f706
--- /dev/null
+++ b/backup-scripts/backup_sql-monthly.sh
@@ -0,0 +1,5 @@
+#!/bin/bash
+mysqldump -u root --all-databases --add-drop-table --events --ignore-table=mysql.event |gzip > 
/home/rootcompujump/backup/monthly/mysql_backup-`date +\%Y-\%m-\%d`.sql.gz
+
+#Esborrar els backups més antics de 1 any
+find /home/rootcompujump/backup/monthly -mtime +366 -execdir rm "{}" "+"
diff --git a/backup-scripts/backup_sql-weekly.sh b/backup-scripts/backup_sql-weekly.sh
new file mode 100755
index 0000000..245d0f8
--- /dev/null
+++ b/backup-scripts/backup_sql-weekly.sh
@@ -0,0 +1,5 @@
+/bin/bash
+mysqldump -u root --all-databases --add-drop-table --events --ignore-table=mysql.event |gzip > gzip > 
/home/rootcompujump/backup/weekly/mysql_backup-`date +\%Y-\%m-\%d`.sql.gz
+
+#Esborrar els backups més antics de 30 dies
+find /home/rootcompujump/backup/weekly -mtime +32 -execdir rm "{}" "+"