Windows 2012 R2,MySQL 5.7
После выполнения операции дамба базы с помощью утилиты mysqldump в результирующем файле ***.sql все русские буквы заменены крокозябрами. Как выгружать в кириллице?
После дамба mysqldump крокозябры в sql файле
Re: После дамба mysqldump крокозябры в sql файле
Разобрался....
A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding:
shell> mysqldump [options] > dump.sql
However, UTF-16 is not permitted as a connection character set (see Section 10.1.5, “Connection Character Sets and Collations”), so the dump file will not load correctly. To work around this issue, use the --result-file option, which creates the output in ASCII format:
shell> mysqldump [options] --result-file=dump.sql
A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding:
shell> mysqldump [options] > dump.sql
However, UTF-16 is not permitted as a connection character set (see Section 10.1.5, “Connection Character Sets and Collations”), so the dump file will not load correctly. To work around this issue, use the --result-file option, which creates the output in ASCII format:
shell> mysqldump [options] --result-file=dump.sql