Skip to content

Instantly share code, notes, and snippets.

@omergorur

omergorur/dump_restore_mysql_utf8mb4.sh

Forked from attilahorvath/dump_restore_mysql_utf8mb4.sh
Created January 16, 2025 14:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save omergorur/fa2555cd98aab24b9ae64af1d594c435 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save omergorur/fa2555cd98aab24b9ae64af1d594c435 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment