Help Center/ Data Replication Service/ User Guide (Paris Region) / Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the TIME_ZONE Values of the Source and Destination Databases Are the Same
Updated on 2023-01-05 GMT+08:00
View PDF
Share

Checking Whether the TIME_ZONE Values of the Source and Destination Databases Are the Same

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.
Parent topic: Database Parameters