utf8mb4 wasn't available until MySQL/5.5.3 but HeidiSQL generates this on SQL dumps:
/*!40101 SET NAMES utf8mb4 */;
... which leads to:
/* SQL Error (1115): Unknown character set: 'utf8mb4' */
... on older servers. I guess it should be:
/*!50503 SET NAMES utf8mb4 */;
... or maybe:
/*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */;
... for some kind of backwards compatibility.
In my case, source database was using
utf8_spanish_ci so I don't need really full UTF-8.
P.S. Love markdown support in forum!