#!/bin/bash

#Backups Folder
cd /backups/mysql/

# Get list of databases
LISTEBDD=$( echo 'show databases' | mysql -uroot -p'techbyvideo' )

# Save the current date
DATE=`date +%y_%m_%d`

##List of databases
for SQL in $LISTEBDD

do

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

## backup database 
mysqldump -uroot -p'techbyvideo' $SQL > ${SQL}_`date +"%Y-%m-%d"`.sql

## Compress file tar.bz2 
tar jcf ${SQL}_`date +"%Y-%m-%d"`.sql.tar.bz2 ${SQL}_`date +"%Y-%m-%d"`.sql

## delete backups 
rm ${SQL}_`date +"%Y-%m-%d"`.sql

fi

done