How to migrate MySql Wordpress database from a newer version of MySql to an older one?

Question

MySQL

I have a site on Wordpress, you need to transfer it from one hosting to another.
But on the hosting where it is now there is a newer version of MYSQL than on the one where it needs to be transferred.
I go to phpMyAdmin where there is a database with a newer version Export - Quick - SQL
in phpMyAdmin on a hosting with an old version Ipmort - select dump - OK
Gives an error
error #1273 - Unknown collation: 'utf8mb4_unicode_ci'
Found this way and did
Open the dump database with any text editor and replace the string "utf8mb4_unicode_ci" with "utf8_general_ci" for all matches found. After that, we save the new version of the dump and import it into MySQL.
Then it started giving an error "Unknown character set: 'utf8mb4'"
found such a way and made
Open a base dump that gives this error with any text editor. Next, we make a replacement for all content:
we change "utf8mb4" to "utf8". After that, save the changes and try to import again. The error should disappear.
The errors have disappeared and the import is working fine, the site works, but there is a feeling that this method is a crutch, because on the new hosting it periodically gives a "database connection error"
Can anyone tell me how to competently transfer the database from a newer version of MYSQL to the old one?

Answer 1

Если после исправления кодировки ошибок при последнем импорте не было - то ищете проблему в другом месте. Например, на новом хостинге не хватает ресурсов (файловых дескрипторов, памяти, ограничено количество одновременных подключений, и т.д.). Смотрите (запрашивайте) логи.