unknown variable 'сollation-connection=utf8_unicode_ci'.
unknown variable 'сollation_connection=utf8_unicode_ci'.
sudo mysqldump -u root -p'' --no-data --defaults-extra-file=/home/add_my.cnf -h localhost sitemanager > /home/bitrix/www/bitrix/backup\_structure.sql[client]
сollation_connection = utf8_unicode_ci
И, как и любой клиент, он получает кучу настроек из секции [client]
сollation_connection = utf8_unicode_cimysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'sitemanager';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8 | utf8_unicode_ci |
+----------------------------+------------------------+root@NAS:/home# dumpe2fs -h /dev/sdb
dumpe2fs 1.43.4 (31-Jan-2017)
Filesystem volume name: <none>
Last mounted on: /home/cams/184
Filesystem UUID: 8d64284d-89aa-4ce2-bd9d-38e71dfa0566
Filesystem magic number: 0xEF53
Filesystem revision #: 1 (dynamic)
Filesystem features: has_journal ext_attr resize_inode dir_index filetype needs_recovery extent 64bit flex_bg sparse_super large_file huge_file dir_nlink extra_isize metadata_csum
Filesystem flags: signed_directory_hash
Default mount options: user_xattr acl
Filesystem state: clean
Errors behavior: Continue
Filesystem OS type: Linux
Inode count: 30531584
Block count: 122096646
Reserved block count: 0
Free blocks: 119899305
Free inodes: 30531573
First block: 0
Block size: 4096
Fragment size: 4096
Group descriptor size: 64
Reserved GDT blocks: 1024
Blocks per group: 32768
Fragments per group: 32768
Inodes per group: 8192
Inode blocks per group: 512
Flex block group size: 16
Filesystem created: Fri Sep 17 14:53:41 2021
Last mount time: Fri Sep 17 14:54:51 2021
Last write time: Fri Sep 17 14:54:51 2021
Mount count: 1
Maximum mount count: -1
Last checked: Fri Sep 17 14:53:41 2021
Check interval: 0 (<none>)
Lifetime writes: 1029 MB
Reserved blocks uid: 0 (user root)
Reserved blocks gid: 0 (group root)
First inode: 11
Inode size: 256
Required extra isize: 32
Desired extra isize: 32
Journal inode: 8
Default directory hash: half_md4
Directory Hash Seed: f8ac6149-046c-4681-a2eb-4456a13b1e4e
Journal backup: inode blocks
Checksum type: crc32c
Checksum: 0x36b025ca
Journal features: journal_incompat_revoke journal_64bit journal_checksum_v3
Journal size: 1024M
Journal length: 262144
Journal sequence: 0x00000002
Journal start: 1
Journal checksum type: crc32c
Journal checksum: 0x69409bdf
По этому ник-нейму ничего не находится конкретного, куча всего не по теме...
Есть, мож хоть ссылка какая?