A dump was made via Navicat Premium, the encoding is in UTF-8 (They say that the base should be kept in win-1251?).
I load this dump through ISPmanager, it is normal to boot when I went to PhpMyAdmin, there are all Russian letters of this type (РР Ð Ð).
I changed the encoding on UTF-8 in the settings of PhpMyAdmin and when loading on the panel it was also in UTF-8, the sql file itself was also in UTF-8 encoding. Can't understand, can you help?

  • For some reason, instead of win1251, you write win1501, the Russian letters “beat” in the direction of cp2151 -> UFT8 (the decoder suggests that your letters “иои РД = ”My l”). - AK
  • Is there a SET NAMES utf8 command inside the dump? In the original table database in Windows-1251? - cheops
  • In UTF-8, but I'm sorry I confused it, 1251. - Albert Ushakov
  • I tried to change on win 1251, everything does not work exactly, instead of curvature, questions are displayed. - Albert Ushakov
  • With wines 1251 displays questions. I don't know what the hell ( - Albert Ushakov

1 answer 1

Found the solution in the internet, after hours of searching. Before that, I configured max file uploads via SSH:

mysql -h hostname -u user-name -default_character_set utf8 -p DB_name < /path-to-dir/dump.sql