Skip to content

Instantly share code, notes, and snippets.

@pioz

pioz/gist:850939

Created March 2, 2011 13:36
Show Gist options
  • Save pioz/850939 to your computer and use it in GitHub Desktop.
Save pioz/850939 to your computer and use it in GitHub Desktop.
Download ZIP
Convert latin1 database in UTF8
Raw
gistfile1.txt
mysqldump DBNAME -u USER -p > backup.sql
cat backup.sql | sed s/latin1/utf8/ > converted.sql
mysql -u USER -p --execute="drop database DBNAME;"
mysql -u USER -p --execute="create database DBNAME character set utf8 collate utf8_general_ci;"
mysql DBNAME -u USER -p < converted.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment