The cause:

You have got the ”utf8mb4_unicode_520_ci” problem because the versions of MySQL in the live server and local server are totally different.

Solution:

You can handle this issue by looking for:

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

Then, let’s convert it into the following command in your .sql file:

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Your problem will be solved effectively by this way.