#!/bin/sh

# echo start message
echo "Backup Script Processing"

# navigate to backup dir
if
        cd /Users/Joni/Documents/Dropbox/Backups/mysql/
then
        echo "...successfully navigated to backup dir"
else
        echo "could not locate backup directory"
        exit 0
fi

# echo message
echo "exporting SQL dump"

if
        #dump the db into a .sql file
        mysqldump --user=root --password=*** --all-databases --lock-tables --add-drop-table > localhost-`date +"%Y-%m-%d"`.sql;
then
        #echo success message
        echo "SQL dump successful"
else
        #echo error message
        echo "mysqldump error"
        exit 0
fi