XF 2.2 Backup and import mysql - problem thread titles

[rosal]

Hi iam trying to import a database to a new server, but the thread titles haves problems i think its the encoding.

Example characters like this ç ão have problems in the thread title, but inside the posts dont have any problem.
I have utf8mb4_general_ci and in the new server database have create the same.
I have used the backup generated from cpanel.

Any special command to import to the new database?

 

[Tracy Perry]

Not so much import... but did you export using the utf8mb4 parameters... in most cases, mySQL does not export in that format unless you tell it to.

 

[rosal]

Its an auto backup from cpanel.

 

[Tracy Perry]

Its an auto backup from cpanel.

And you know for a fact that it exports in the same format?
Have you looked at the actual dump file it gives you to confirm that... or are you simply assuming?
I don't use cPanel as for me, it's a waste of resources that could be applied elsewhere... so have no active knowledge of it.

 

[rosal]

And you know for a fact that it exports in the same format?

What is the best way to do that?
Its a large sql file 2G.

 

[MattW]

Unless you have specifically set the mysqldump option in your my.cnf file, the cPanel backups won't use the correct utf8mb4 option in the backup dumps

[mysqldump]
quick
max_allowed_packet = 80M
default-character-set=utf8mb4

 

[rosal]

If i edit with notepad++ the titles names are ok so the database that cpanel makes autobackup are ok.

Strange, any clues?

 

[Kirby]

Strange, any clues?

Skip the GUI crap, create the dump from shell using plain mysqldump --default-character-set=utf8mb4, import with mysql --default-character-set=utf8mb4.

I am pretty sure you won't have any issues that way.

Btw: 2G isn't large.