自动备份mysql 07-backup-db.sh

#!/usr/bin/env bash

today()
{
    date +%Y-%m-%d-%H-%M
}

echo "backup db stating ........"
sql_file_name=$1
if [ -z "$sql_file_name" ]; then
    echo "ss"
else
    prefix = today()

    path = /eship/db-backup/'$prefix'_'$sql_file_name'
    mkdir -p '$path'

    mysqldump -uroot -p123456 14_eship_author > '$path'/14_eship_author.sql

   echo "ss"
fi