When you migrate a database are lost, the letters "I" And "y". What could be the reason?

Hello. Using Phpmyadmin transfer mysql database from one host to another. After the transfer of the letter "I" and "s" are displayed incorrectly. Encoding tables cp1251_general_ci. Put the script in utf-8. If the script set the encoding to windows-1251 it does not become readable Russian letters. Prompt how correctly to transfer?
June 14th 19 at 20:39
1 answer
June 14th 19 at 20:41
But in the final database (which carry data), the encoding (mapping) tables/columns are the same as the base from which data are You trying to transfer?

PS Strongly recommend You to use InnoDB (or similar) as the main engine (type) table, and encoding of utf8_general_ci (or some other variation of UTF-8, to Your taste), unless You are trying to squeeze out of the base of the "last juice" in terms of performance, to the detriment of stability and potentially lower the number of silly stuff related to encodings.
Thanks, but unfortunately, I did not decide what character set encoding in the database.
End database encoding matches the encoding of the database source. - Alva commented on June 14th 19 at 20:44
the , uh... I figured, let's try easier. You have access to the server via console (SSH)? If so, you can try to dump on the source using mysqldump, respectively. if you have SSH on the secondary server, you through it to try to restore the dump there.

The second point - try to dump the source in two encodings, as You originally described, and in UTF-8 and CP-1251, then open both dump in the editor and see what each of the dumps written? We are interested in some kind of string that is encoded in CP-1251 will "bat" in a file dump.

Once we understand, finally, where the source of the problem, the source or recipient, it will be possible more concretely to solve the issue. - Salvado commented on June 14th 19 at 20:47

Find more questions by tags Character encodingMySQL