When transferring the base, the letters "I" and "s" are lost. What could be the reason?

Question

MySQL

Hello. Using Phpmyadmin I transfer mysql database from one hosting to another. After the transfer, the letters "I" and "ы" are displayed incorrectly. cp1251_general_ci table encoding. I set the script to utf-8 encoding. If I set the encoding to windows-1251 to the script, then all Russian letters become unreadable. Tell me how to transfer?

Answer 1

And in the final database (to which you are transferring data), the encoding (collation) of tables / columns matches the database from which you are trying to transfer data?
PS I strongly recommend that you use InnoDB (or its equivalent) as the main engine (type) of tables and the encoding utf8_general_ci (well, or some other variation of UTF-8, to your taste), unless of course you are trying to squeeze the "last juice" out of the database "in terms of performance, to the detriment of stability and potentially less nonsense related to encodings.