vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/drs/umn/drs_11_0013.html
Wang , Deng Ke 5523220f09 DRS UMN 20221102 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-12-08 10:16:13 +00:00

5.5 KiB
Raw Permalink Blame History

Checking Whether the Source and Destination Database Character Sets Are Consistent

MySQL Migration

Table 1 Checking whether the source and destination database character sets are consistent

Check Item

Whether the source and destination database character sets are consistent

Description

Check whether the character sets of the servers hosting the source and destination databases are consistent.

Failure Cause and Handling Suggestion

Failure cause: This item cannot be checked because the source database fails to be connected.

Handling suggestion: Check whether the source database is connected.

Failure cause: This item cannot be checked because the destination database fails to be connected.

Handling suggestion: Check whether the destination database is connected.

Failure cause: Insufficient user permissions

Handling suggestion: Check whether the database user permissions meet the migration requirements.

Failure cause: The character set of the source database is inconsistent with that of the destination database.

Handling suggestion: Modify the character sets.

Run commands to modify the self-created source database.

  1. Check whether source and destination database character sets are consistent.
    show variables like "character_set_server"\G;

  2. Modify the character set of the source database server.
    set character_set_server='utf8';

Failure cause: An internal error occurs.

Handling suggestion: Contact technical support.
Parent topic: Database Parameters