[Script] mysql 덤프

[ 단순 mysql 덤프 ]

#!/bin/sh

DATE=`date +"%Y%m%d%H%M%S"`

USERNAME="root"

PASSWORD="패스워드비공개"

DATABASE="test"

mysqldump -u$USERNAME -p$PASSWORD  $DATABASE > /backup/mysql_db_bak_${DATE}.sql