Presentation

The goal of this simple BASH script is to automate the backup of databases on a MySQL Server using a minimal set of tools.

Features

• Backup one or multiple databases and compress the .sql dumps in a Zip archive ;
• Set a custom backup location ;
• Set a custom name for the backups ;
• Send E-Mail at the end of each step ;
• Automatically delete backups older than a custom number of days ;

The code is made so that it is easy to read and understand and can be adapted to specific use-cases.

Dependencies

• The cron job scheduler ;
• The zip CLI tool ;
• A mail transfer agent such as exim4 or sendmail ;

Installation

1. Clone this repository in you home directory
2. Move db_backup_script.sh to a dedicated directory (for example, in a .script directory, in your home directory) ;
3. Edit the file to replace the placeholders with the wanted values:

In VARIABLES, replace at:

<webdir>, <backupdir>, <recipient_email>, <keep_day>, <webfiles1> and <webfiles2>

In BACKUP CREATION & COMPRESSION, replace at:

"yourStrongPassword" with a custom password ;

4. Give this file execution permissions and change owner to root:

$ chmod 700 /path/to/the/.script/web_backup_script.sh && chown root:root /path/to/the/.script/web_backup_script.sh

5. Edit /etc/crontab and at the end, add:

00 0    1 * *   root    sh /path/to/the/.script/db_backup_script.sh

This will execute the script on the first of each month at 0:00.

6. To make sure there are no errors in the script, run it using:

# sh /path/to/the/.script/db_backup_script.sh

WARNING !

THIS SCRIPT IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR ANYONE DISTRIBUTING THE CODE BE LIABLE FOR ANY DAMAGES OR OTHER LIABILITY, WHETHER IN CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE CODE OR THE USE OR OTHER DEALINGS IN THE CODE.

THIS PROJECT MAY NOT BE USED FOR THE PURPOSE OF TRAINING OR IMPROVING MACHINE LEARNING ALGORITHMS. PLEASE, READ THE LICENSE'S TERMS.