Skip to content

Instantly share code, notes, and snippets.

@schwabix

schwabix/MySQL Dump UTF-8 save

Created March 16, 2017 12:35
Show Gist options
  • Save schwabix/0230a9a2f25f9cd331f8a4a31ca09997 to your computer and use it in GitHub Desktop.
Save schwabix/0230a9a2f25f9cd331f8a4a31ca09997 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL Dump UTF-8 save
mysqldump -u<USER> -h<HOST> -p --lock-tables=false <DB> -r dump.sql
mysql -u<USER> -p --default-character-set=utf8 <DB>
mysql> SET names 'utf8';
mysql> SOURCE dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment