attilahorvath/dump_restore_mysql_utf8mb4.sh

Created March 13, 2015 13:33

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/attilahorvath/f83596970d9f50cd5a83.js"></script>
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

mstrouhal commented Jan 5, 2020

thanks!

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