MySQL, Maria DB 백업 쉘 스크립트
무결성 보장 : single-transaction 한글지원 : default-character-set=utf8 #!/bin/sh ## yyyymmdd_hhmm format DATE=$(date "+%Y%m%d") TIME=$(date "+%Y%m%d_%H%M") PATH="/home/woohaeng/MyDisk/Backup/MySql" PATHTIME=${PATH}/${DATE}/${TIME} #/bin/mv ${PATH}*.sql "/media/vf-db/Seagate Backup Plus Drive/DB백업" cd ${PATH} /bin/mkdir ${DATE} /usr/bin/mysqldump --single-transaction --databases qhedge_dev_daily -h localh..
프로그램
2020. 3. 2. 19:55