Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source and Destination Database TIME_ZONE Values Are Consistent
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source and Destination Database TIME_ZONE Values Are Consistent

MySQL

Table 1 Checking whether the TIME_ZONE values of the source and destination databases are the same

Check Item

Whether the TIME_ZONE values of the source and destination databases are the same

Description

The migration fails because the TIME_ZONE values of the source and destination databases are different.

Failure Cause and Handling Suggestion

Failure cause: The TIME_ZONE or SYSTEM_TIME_ZONE values of the source and destination databases must be the same.

Handling suggestion: Change the TIME_ZONE value of the destination database to the same as that of the source database, or change the TIME_ZONE value of the source database to the same as that of the destination database.