Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOG_LOCATION=/var/log.txt
- rm backup.sql
- mysqldump -h source_host -u"source_user" -p"source_password" "source_db" > backup.sql
- action="$((mysql -h destination_host -u"destination_user" -p"destination_password" "destination_db" < backup.sql) 2>&1)"
- echo "Log " $(date +'%d-%m-%Y %H:%M:%S') "$action" >> $LOG_LOCATION
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement