Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash -e
- DB_HOST="$1"
- DB_USER="$2"
- DB_PASSWORD="$3"
- DB_NAME="$4"
- mysqldump -h "$DB_HOST -u "$DB_USER" -p"$DB_PASSWORD" --opt --quote-names \
- --skip-set-charset --default-character-set=latin1 "$DB_NAME" > /tmp/temp.sql
- mysql -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASSWORD" \
- --default-character-set=utf8 "$DB_NAME" < /tmp/temp.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement