DB Transfer Encoding issues

[msoms]

Hello,

I am facing an issue that took a while for me now and am not moving any where and got stuck. I have vB 4.2.5 with DB size of around 6.5 GB. I am changing to a new server and I have already migrated all my other sites (wordpress based) with no issues at all and they work just the way they should.

I followed the normal mysqldump commands to backup and restore several times and in several types however, the site will always show strange text encoding.
Both servers use MySQL correct versions and PHP7.
I can't seem to figure out what is wrong exactly.

The old server was CENTOS 6 with CPANEL and the new server is DEBIAN 9 with ISPCONFIG ,does that have any issue? Does MariaDB in new server has an effect on normal mysql in old server? both server encoding is UTF-8

I am lost and already initated a support request with vb team but no response till now.

Can you please help?

[Dave]

Where does it show the strange text encoding? Do you have a screenshot?
Do posts also look messed up? If you check the post table in the database, does it look fine there?

[msoms]

The whole site encoding is messed up! Not a single line is showing correctly, however on the db side it is ok.

I tried changing the charset for the installed languages and I can see some changes in the messed up text but no luck in making it work.

I will arrange for a screen shot in the mean while

[snakes1100]

Is there a php.ini in the domains public_html folder, verify it dont have a charset setting in it.

Plesk is known to do that with their inserting a charset by default in an account.

[msoms]

Is there a php.ini in the domains public_html folder, verify it dont have a charset setting in it.

Plesk is known to do that with their inserting a charset by default in an account.

No there isn't, I am using ISPConfig 3 control panel not Plesk.

[webmastersun]

I followed the normal mysqldump commands to backup and restore several times and in several types however, the site will always show strange text encoding.


There are some works to do before moving your database to a new server that support and keep same encode, that is:
- Select utf8 unicode ci for your database.
- Enable force to use utf8 in your config file
- Change encode to utf8 in your tool/program that you are using to move your database.

This will help you to avoid errors about special characters/symbol when moving vB databases.

[snakes1100]

No there isn't, I am using ISPConfig 3 control panel not Plesk.

I didnt say you was using plesk.