About This Little Script

SQLBackup is a powerful and easy customizeable shell script (.sh) that helps you to make SQL databases backups and clean old backups automatically. The backup functionality is implemented using the commands of the mysqldump utility.

Questions & Answers

Q: What do I need to use this script?
A: MySQL >5.7 version or MariaDB >10.3.23 version

Q: Will I be able to automate the execution of the script?
A: Of course, like any other shell script, it can be called automatically by the system or programs.
You can use cron as an ideal solution to this question. Move to cron setup guide.

Q: Can I track the execution of a script in specific log file?
A: Currently, no. But I have already planned to implement this ;)

Installation

1. Clone sqlbackup.sh into the desired directory /etc/mysql/ for example
2. Open sqlbackup.sh file and move to 64 line. There are the mysqldump commands to perform backups.
   Follow my instructions in comments and choose the option you need.

#######################################################
###              Backup Script Body                 ###
#######################################################

# Use this command if your user have password
/usr/bin/mysqldump -u ${user} -p ${password} ${DATABASE1} > $directory/${DATABASE1}$dateformat.$ext
echo "${OK} ${DATABASE1} saved."

# Use this command if your user have NOT password (root as usually)
/usr/bin/mysqldump -u ${user} ${DATABASE1} > $directory/${DATABASE1}$dateformat.$ext
echo "${OK} ${DATABASE1} saved."

3. Move to the top of the file and set the required values in Backup Module Settings.
   If your user does not have a password and you chose the second option in step 3, the password field can be left unchanged.
4. If you want to perform cleanup after script execution, set enable_clean to 1 and set the required parameters below.
   DANGER: CHECKUP YOUR CLEAN_DIRECTORY VAR BEFORE STARTING CLEAN MODULE
5. Move to the directory where the script is located and run it:

cd /path/to/script && sh sqlbackup.sh

6. Check up backup files directory to make sure everything is set up correctly.

Setup Сron Task

If you need to run this script automatically, you can add the following task:

* * * * * cd /path/to/script && sh sqlbackup.sh

You can edit this rule to change the start interval.
The rule below runs the script every 6 hours at 00 minutes.

0 */6 * * * cd /path/to/script && sh sqlbackup.sh