backup_prestashop_db.sh

#!/bin/bash
# Script reads configuration values from Prestashop settings,
# and makes database dump into default prestashop backup folder (adminXYZ1234/backups).

function get_parameter_value() {
    echo $(cat $PARAMETERS | grep $1 | awk '{print $3}' | sed -e "s/[',]//g")
}

PARAMETERS=../public_html/app/config/parameters.php
DB_NAME=$(get_parameter_value database_name)
DB_USER=$(get_parameter_value database_user)
DB_PASSWORD=$(get_parameter_value database_password)
OUTPUT_PATH=../public_html/$(ls ../public_html/ | grep "^admin")/backups/

mysqldump --user=$DB_USER --password=$DB_PASSWORD --host=localhost --default-character-set=utf8 "$DB_NAME" > db_backup.sql

OUTPUT_FILENAME=$(date +%s)-$(md5sum db_backup.sql | cut -c -8).sql.gz
gzip -c db_backup.sql > $OUTPUT_PATH/$OUTPUT_FILENAME
rm db_backup.sql
ls $OUTPUT_PATH/$OUTPUT_FILENAME;