mysqlbackup.sh

 #!/bin/bash

#date du jour
DATE=`date +%y_%m_%d`

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

for SQL in $LISTEBDD

do

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

#echo $SQL
mysqldump -uroot -pPWD $SQL --skip-lock-tables | gzip > /home/user/sql/$SQL"_mysql_"$DATE.sql.gz

fi

done