Skip to content

Instantly share code, notes, and snippets.

@felipepodesta

felipepodesta/changeEncodingFromNEWToOLDInMySQL.sh

Forked from karlazz/change encoding from new to old in mysql
Last active October 30, 2017 18:56
Show Gist options
  • Save felipepodesta/bc7b7d9c2cfd7009eff3b71439c12445 to your computer and use it in GitHub Desktop.
Save felipepodesta/bc7b7d9c2cfd7009eff3b71439c12445 to your computer and use it in GitHub Desktop.
Download ZIP
Change encoding from NEW to OLD in MySQL
Raw
changeEncodingFromNEWToOLDInMySQL.sh
sed -ie 's/utf8mb4_unicode_520_ci/utf8_general_ci/g' mysql.sql
sed -ie 's/CHARSET=utf8mb4/CHARSET=utf8/g' mysql.sql
sed -ie 's/utf8mb4_unicode_ci/utf8_general_ci/g' mysql.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment