Issue Unable to import the database_name dump:

[eslammahmoud]

hi
I have a problem in database

ERROR 1273 (HY000) at line 40830: Unknown collation: 'uft8_general_ci'

How to solve it !!

 

[IgorG]

Check the version of your SQL server with

# plesk db -Ne "select version()"

and make sure that collation mentioned in the error message is not available in MySQL server:

# plesk db -e "show collation" | grep uft8_general_ci
#

So you have to upgrade MariaDB to version 10.1 or 10.2 on the destination server. For instructions, visit this KB article.