Charset issues after transfer to new server

[BugsBunnyWCV]

Hello,

We have moved our server to our new hosting provider, but we are having some issues.

Now, we cannot open up the admincp and also some issues with character set mismatch between the board and mysql.

We understans that he character sets in the database collation field and within IP.Board need to match, but we can make it work.

The error logging into the admincp, seems to be related to the other issues of charset also, but we can seen to find where is the mismatch between both servers.

Is there a way that you guys can help is with the issues? We have tried everything and the 2 issues are still present.

We are going in the 2nd week with the board down.

Your assistance will be greatly appreciated.

Thank you.

[PatrickRQ]

Well, if you just moved the board to another server then the only fault is done by you. You should create database with same collation and charset as the one from before the move then restore the backup over it. This is the solution.

This is not an issue of mysql -> IPB, this is an issue of mismatch of Database's collation/chatset -> backup's collation/charset

[BugsBunnyWCV]

Well, if you just moved the board to another server then the only fault is done by you. You should create database with same collation and charset as the one from before the move then restore the backup over it. This is the solution.

This is

not

an issue of

mysql

->

IPB

, this is an

issue of

mismatch of

Database's collation/chatset

->

backup's collation/charset

Thank you David,

So where do I found the charset information from the old and new server.

We have tried few times but are still getting same error. We are just desperate right now n

[PatrickRQ]

You should check that information before you started proceed with the move.


Now you need to go phpmyadmin, enter the desired DB, and check what is listed in collation column for your tables, collation of db should be set same.

However, complete info of your db can be be obtained by using following command:

USE your_database_of_interest;

and type,

show variables like "character_set_database";
show variables like "collation_database";

However, charaset of your tables may be different, so verify tables and columns also.. 2 of them is enough to determine.. then set databases collation and charset same as tables' one

use..

SELECT default_character_set_name FROM information_schema.SCHEMATA S

WHERE schema_name = "schemaname";

For Tables:

SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,

       information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA

WHERE CCSA.collation_name = T.table_collation

  AND T.table_schema = "schemaname"

  AND T.table_name = "tablename";

For Columns:

SELECT character_set_name FROM information_schema.`COLUMNS` C

WHERE table_schema = "schemaname"

  AND table_name = "tablename"

  AND column_name = "columnname";