Skip to content

Instantly share code, notes, and snippets.

@jaguerra

jaguerra/fix-double-encoding.sh

Last active December 10, 2015 10:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jaguerra/4419878 to your computer and use it in GitHub Desktop.
Save jaguerra/4419878 to your computer and use it in GitHub Desktop.
Download ZIP
Fix double encoded utf-8 in mysql
Raw
fix-double-encoding.sh
#!/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment