Skip to content

Instantly share code, notes, and snippets.

@attilahorvath

attilahorvath/dump_restore_mysql_utf8mb4.sh

Created March 13, 2015 13:33
Show Gist options
  • Save attilahorvath/f83596970d9f50cd5a83 to your computer and use it in GitHub Desktop.
Save attilahorvath/f83596970d9f50cd5a83 to your computer and use it in GitHub Desktop.
Download ZIP
Dump/restore MySQL database with utf8mb4 encoding
Raw
dump_restore_mysql_utf8mb4.sh
# dump
mysqldump -u user -p database --default-character-set=utf8mb4 --result-file=dump.sql
# restore
mysql -u user -p database < dump.sql
@e7
Copy link

e7 commented Nov 7, 2019

thanks!

@mstrouhal
Copy link

thanks!

@vzool
Copy link

vzool commented Mar 27, 2022

restore

mysql -u user -p database --default-character-set=utf8mb4 < dump.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment