I used the Scheduled Backups feature to back up my website. Unfortunately, my hosting plan expired and the data was deleted, but I still have the previous backups saved. However, when I restored the database, all the website content failed to display correctly in Vietnamese, even though I selected the utf8mb4_unicode_ci collation.
I also tried other collations like utf8mb4_general_ci, utf8mb4_vietnamese_ci, utf8_unicode_ci, etc., but none of them worked. I’m really worried because the database contains a large amount of important data.
If the data is being stored in a database, and that database after importing is not showing data correctly, I’d recommend reaching out to the appropriate database community or vendor. They’re more likely going to have a bit more intel on how to address the matter, as it’s their wheel house.
MariaDB website suggests amongst other methods, visiting:
chances are your data is still there if the backup was good.
When you set utf8mb4_unicode_ci collation on a database and then import, this will only change tables that have not specific collation set (i.e. use the default collation for this database).
Manually check the SQL file and see what the collation should be.
