Приемы по резервному копированию

Резервирование базы MySQL

#!/bin/bash
echo "Архивируем дамп"
myvar=$(mysql -u root damucrm -e "select group_concat(code separator ' ') users from entities where code  not in ('users','table_log_dtls','error_logs','bp_instances','imp_task_rows') and code in (select table_name from information_schema.tables where table_schema=database())")
if [ $? -eq 0 ]
then
  echo "The script ran ok"
else
  echo "The script failed" >&2
  exit 1
fi
mysqldump --routines -uroot damucrm $myvar "i\$entity_publish" "i\$increment_version_num" "i\$bp_process_publish" > /opt/backup/gitlab/portal1_test_db/portal1_test_full_current.sql
echo "Положим в gitlab"
cd /opt/backup/gitlab/portal1_test_db/
git add .
git commit -m "daily autocommit"
git push origin master
echo "ok gitlab"