Mysql Workbench Dump/Restore using utf8mb4 charset

mysql_workbench_utf8mb4.txt

# dump
/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --host=your_host --port=3306 --default-character-set=utf8mb4 --user=your_user --protocol=tcp -p your_database > dump.sql

# restore
/Applications/MySQLWorkbench.app/Contents/MacOS/mysql --host=your_host --port=3306 --default-character-set=utf8mb4 --user=your_user --protocol=tcp -p your_database < dump.sql

# when you see error "ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation"
From dump.sql file remove following lines:
-- SET @@SESSION.SQL_LOG_BIN= 0;
-- SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '';
-- SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;