mysql-backup.sh

#!/bin/bash

#date du jour
DATE=`date +%y_%m_%d_%H-%M`
mkdir /var/backup/mysql/$DATE

#liste des dossier
LISTEBDD=$( echo 'show databases' | mysql -uroot -pPASSWORD )

#on boucle sur chaque dossier (for deupe automatiquement par l'espace)
for SQL in $LISTEBDD

do

if [ $SQL != "information_schema" ] && [ $SQL != "performance_schema" ] && [ $SQL != "phpmyadmin" ] && [ $SQL != "mysql" ] && [ $SQL != "Database" ] ; then

#echo $SQL
mysqldump --skip-lock-tables -uroot -pPASSWORD $SQL | gzip > /var/backup/mysql/$DATE/$SQL"_mysql".sql.gz

fi

done

cd /var/backup/mysql/

tar -cvf ${DATE}.tar $DATE/*
rm -rf $DATE