tar: *.sql: Cannot stat: No such file or directory
tar: Error exit delayed from previous errors
tar: Cowardly refusing to create an empty archive
Try `tar --help' or `tar --usage' for more information.

SCRIPT BELOW

#!/bin/bash

MyUSER=""     # USERNAME
MyPASS=""       # PASSWORD
MyHOST="localhost"          # Hostname

# Backup Dest directory, change this if you have someother location
DEST="/backup"

# Main directory where backup will be stored
MBD="$DEST/mysql"

mkdir -p "$MBD"

# Get hostname
HOSTNAME="$(hostname)"

# Get data in dd-mm-yyyy format
NOW="$(date +"%d-%m-%Y")"

# File to store current backup file
FILE=""
# Store list of databases
DBS=""

# DO NOT BACKUP these databases
IGGY="information_schema"

# Only root can access it!
chown 0.0 -R "$DEST"
chmod 0700 "$DEST"

# Get all database list first
DBS="$("$MYSQL" -u "$MyUSER" -h "$MyHOST" -p "$MyPASS" -Bse 'show databases')"

for db in $DBS
do
    skipdb=-1
    if [ "$IGGY" != "" ];
    then
    for i in $IGGY
    do
        [ "$db" == "$i" ] && skipdb=1 || :
        done
    fi

    if [ "$skipdb" == "-1" ] ; then
    FILE="$MBD/$db.$HOSTNAME.$NOW.sql"
    # do all inone job in pipe,
    # connect to mysql using mysqldump for select mysql database
    # and pipe it out to gz file in backup dir :)
        "$MYSQLDUMP" -u "$MyUSER" -h "$MyHOST" -p "$MyPASS" "$db" > "$FILE"
   fi
done

tar -zcf mysqlBackup."$NOW".tar.gz *.sql

########################################################################################

#This will backup ones home directory to /backup then cp to /mnt/backup and tar it

#specify the username for the home directory you want to backup
userName=""

#user directory to backup
homeDirectory="/home/$userName"

#main backup directory
backupDestination="/backup"

#backup subdirectory
subDir="$backupDestination/homeBackup"

mkdir -p "$subDir"

cp -r "$homeDirectory" "$subDir"

#naming convention for files
fileName="$subDir/$userName.$NOW.tar.gz"

#tars the file
tar -zcf "$fileName"

#checks to see if the directory exists otherwise it creats the directory
mkdir -p /mnt/backup/

#this copies recursivly the backup directory and subdirectories to /mnt/backup
cp -r /backup /mnt/backup/

########################################################################################

#will check to see if files are older than 8 days if older then 8 days they are deleted

find /backup -mtime +7 -delete

find /mnt/backup -mtime +7 -delete