How To Backup MySQL databases using a shell scripts

MySQL is one of the most popular open source database management system for the development of interactive websites.
If your server stores its sensitive data in a MySQL database, you will most definitely want to backup that information so that it can be restored in case of any disaster.
Below is a backup script for MySQL databases (please make sure you will change MYSQL_PASS):

01

#!/bin/sh

02	# backup mysql databases shell script

03	# UNIX LINUX BSD

04	# by Adi http://blog.up-link.ro

05	# March 2010

06

07	DATE=$(date +%Y-%m-%d)

08	MYSQL=$(which mysql)

09	MYSQLDUMP=$(which mysqldump)

10	MYSQL_USER="root"

11	MYSQL_PASS="password"

12	HOSTNAME=$(hostname)

13	GZIP=$(which gzip)

14	ARG="-u $MYSQL_USER -p$MYSQL_PASS"

15	DATABASES=$($MYSQL $ARG -s -e "SHOW DATABASES;")

16	BACKUP_PATH="/home/backup/$DATE/mysql"

17

18	! [ -d $BACKUP_PATH ] && mkdir -p $BACKUP_PATH

19

20	for DB in $DATABASES

21

do

22	BACKUP_FILE="$BACKUP_PATH/$HOSTNAME-mysql-$DB-$DATE.sql.gz"

23	$MYSQLDUMP $ARG $DB | $GZIP -9 > $BACKUP_FILE

24

done