This error is caused when there is a difference in the MySQL server from which you have exported the database and the MySQL server to which you are importing.
To overcome this error, you will have to edit your SQL file and perform a search and replace, changing all instances of ‘utf8mb4unicode520ci’ to ‘utf8mb4unicode_ci’.
Utilising command line will be much easier here:
Save the SQL file in a directory. eg /root
Go to that directory using:
- Use sed to replace the string:
sed -i 's/utf8mb4unicode520ci/utf8mb4unicode_ci/g' database.sql
Replace the filename database.sql with the exact name.
Try importing this SQL file again.
Keep us posted if you need any further guidance on this and if there are additional questions or concerns please don't hesitate to reply with them.