DB Backup

#!/bin/sh

# echo start message
echo "Backup Script Processing"

# navigate to backup dir
if
cd /Volumes/Backup/db/
then
echo "...successfully navigated to backup dir"
else
echo "could not locate backup directory"
exit 0
fi

# echo message
echo "exporting SQL dump"
now=$(date -u +\%d-\%m_Time_\%H_\%M_\%S)
if
#dump the db into a .sql file
mysqldump --user=user --password=password bazadedate --lock-tables --add-drop-table > bazadedate_$now.sql;
then
#echo success message
echo "SQL dump successful"
else
#echo error message
echo "mysqldump error"
exit 0
fi