[chronojump-server] Added cron to howto

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

commit d67564d59b5a7b1b2f619a0c1edfa403da1cb99a
Author: Xavier Padullés <x padulles gmail com>
Date:   Mon Jul 1 18:09:18 2019 +0200

    Added cron to howto

 backup-scripts/backup_sql-annually.sh |  2 +-
 backup-scripts/backup_sql-daily.sh    |  2 +-
 backup-scripts/backup_sql-weekly.sh   |  2 +-
 howto_install_networks_server.txt     | 20 ++++++++++++++++++++
 4 files changed, 23 insertions(+), 3 deletions(-)
---
diff --git a/backup-scripts/backup_sql-annually.sh b/backup-scripts/backup_sql-annually.sh
index ee0c7e1..0d08b52 100755
--- a/backup-scripts/backup_sql-annually.sh
+++ b/backup-scripts/backup_sql-annually.sh
@@ -1,3 +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
+mysqldump -u root --all-databases --add-drop-table --events --ignore-table=mysql.event |gzip > 
/home/rootcompujump/backup/annually/mysql_backup-`date +\%Y-\%m-\%d`.sql.gz
 
diff --git a/backup-scripts/backup_sql-daily.sh b/backup-scripts/backup_sql-daily.sh
index fe9cfba..31bbd8b 100755
--- a/backup-scripts/backup_sql-daily.sh
+++ b/backup-scripts/backup_sql-daily.sh
@@ -1,4 +1,4 @@
-#/bin/bash
+#!/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
diff --git a/backup-scripts/backup_sql-weekly.sh b/backup-scripts/backup_sql-weekly.sh
index 245d0f8..838bfa7 100755
--- a/backup-scripts/backup_sql-weekly.sh
+++ b/backup-scripts/backup_sql-weekly.sh
@@ -1,4 +1,4 @@
-/bin/bash
+#!/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
diff --git a/howto_install_networks_server.txt b/howto_install_networks_server.txt
index 998ff49..cc139c7 100644
--- a/howto_install_networks_server.txt
+++ b/howto_install_networks_server.txt
@@ -153,3 +153,23 @@ cp /srv2/api-app/services/start_chronojump-server.sh /usr/local/bin/
 chmod +x /usr/local/bin/start_chronojump-server.sh
 cp /srv2/api-app/services/chronojump-server.service /etc/systemd/system
 systemctl start chronojump-server
+
+
+- SQL backups
+
+
+mkdir /home/rootcompujump/backup
+cd backup
+mkdir daily
+mkdir weekly
+mkdir monthly
+mkdir annually
+
+apt-get install cron
+crontab -e
+- Add the following lines
+
+0 0 * * * /srv2/api-app/backup-scripts/backup_sql-daily.sh
+0 1 * * 1 /srv2/api-app/backup-scripts/backup_sql-weekly.sh
+0 2 1 * * /srv2/api-app/backup-scripts/backup_sql-monthly.sh
+0 3 15 1 * /srv2/api-app/backup-scripts/backup_sql-annually.sh