Skip to content

Instantly share code, notes, and snippets.

@vzool

vzool/dump_restore_mysql_utf8mb4.sh

Forked from attilahorvath/dump_restore_mysql_utf8mb4.sh
Created March 27, 2022 11:04
Show Gist options
  • Save vzool/010d40283d005afef298abf7f12b0f21 to your computer and use it in GitHub Desktop.
Save vzool/010d40283d005afef298abf7f12b0f21 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 --default-character-set=utf8mb4 < dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment