We came across an interesting situation while importing database of a WordPress website from one server to another that throws "WordPress Unknow Collation" error. The error generated while importing the database (on destination server) which is downloaded from other (source) server simply halts the import process. This let only a few WordPress tables to get imported and remaining won't get imported. It says Unknown Collation and thus the database was not being able to get imported as the destination collation was not supported by the source database server. To fix this, we found a...