Import mysql 5.5 dump in to 5.1

Table of Contents

If your getting the error Unknown collation: ‘utf8mb4_unicode_ci‘ Its probally becuase you trying to inport a 5.5 export to a 5.1 databse.

You can try changing

CHARSET=utf8mb4 to CHARSET=utf8

COLLATE=utf8mb4_unicode_ci COLLATE=utf8_general_ci

This will only work if you don’t have invalid caratuers in your mysql dump but it may help.