Sunka
Well-known member
Actually to be on safe side you'd want to do mysql import with
Code:mysql --default-character-set=utf8mb4
as your may have uf8mb4 mysql table and field character set/collations but your mysql client connection my not be utf8mb4 based and mysql server default client might be a different character set and collation from utf8mb4 i.e. utf8
So, for backup database, this should be it?
Code:
/usr/bin/mysqldump --opt xenforo --default-character-set=utf8mb4 > /home/nginx/domains/example.com/backup/ssh_database/ssh_backup.sql
But regarding your import setting, would it be like this or...?
Code:
mysql --default-character-set=utf8mb4 NewDatabaseName < /home/nginx/domains/example.com/backup/ssh_database/ssh_backup.sql