Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #----------------------------------------------------
- #thank to my cat {miao miao} who inspire me pull this code to github
- #this script is remember him who passaway in this day 2016-11-17 because get anemia and you always be remember in my deep heart
- #credit to miao either nite or morning stay with me when i still coding
- #----------------------------------------------------
- #!/bin/bash
- # this script only dump db selected
- # Database credentials
- # db username
- # db password
- # db name
- # db which need restore
- # output directory --> example OUTPUT="/home/desktop/"
- # %d-%b-%Y example 18-Nov-2016
- # %Y%m%d example 20161118
- # file exists
- # control to clear function
- USER="root"
- PASSWORD="1234qwer"
- DB_NAME="etrade"
- BACKUP_db="etrade_bk"
- store_loc="${PWD}/honey_pot"
- date=$(date +"%Y%m%d")
- date_dbss=$(date +"%Y%m%d-%H%M%S")
- file=$store_loc/"etrade_today.sql"
- $clean_process = false
- #create a directory for store this db
- if [ -d "$store_loc" ] ; then
- echo $store_loc "Found"
- else
- mkdir -p $store_loc
- echo $store_loc "Not Found"
- fi
- # Delete files older than 30 days
- # -f FILE exists and is a regular file
- # -e FILE exists
- #if [ -f $file ] ; then
- # echo $file "Found"
- #rm "$OUTPUT/*gz" > /dev/null 2>&1
- #else
- # echo $file "Not Found"
- #fi
- if [ $clean_process ] ; then
- echo "Clear Process is on"
- find $store_loc/* -mtime +30 -exec rm {} \;
- else
- echo "Clear Process is off"
- fi
- databases=`mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
- for db in $databases; do
- if [[ "$db" == $DB_NAME ]]; then
- echo "Dumping database: $db"
- #mysqldump --force --opt --user=$USER --password=$PASSWORD --databases $db > $OUTPUT/$db"_"`date +%Y%m%d-%H%M%S`.sql
- mysqldump -u$USER -p$PASSWORD $db > $store_loc/$db"_today".sql
- #gzip $OUTPUT/`date +%Y%m%d`.$db.sql
- fi
- done
- filename=$(basename "$file")
- extension="${filename##*.}"
- filename="${filename%.*}"
- # copy file
- if [ -f $file ] ; then
- cp $file $store_loc/"etrade_"$date_dbss.sql
- fi
- #restore databases
- #if [ -f $file ] ; then
- # mysql -u$USER -p$PASSWORD $BACKUP_db < $file
- #else
- # echo $file "- not found."
- #fi
- #delete databases today
- #if [ -f $file ] ; then
- # echo $file "will be delete"
- #${PWD}/"etrade_today.sql -> this file will be delete
- # rm $file
- #echo $OUTPUT/*sql
- #echo "Any [.sql] file in this directory will be delete"
- #rm $OUTPUT/*sql
- #fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement