My Oracle Support Banner

FAQ: MySQL Time Zone Support; mysql_tzinfo_to_sql (Doc ID 2232820.1)

Last updated on APRIL 03, 2018

Applies to:

MySQL Server - Version 5.0 and later
Information in this document applies to any platform.

Purpose

To provide an overview of common questions related to loading time zone data into MySQL and using the mysql_tzinfo_to_sql script.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Q1. How to install time zone support in MySQL?
 Q2. Which tables will be changed by executing the SQL generated by mysql_tzinfo_to_sql?
 Q3. Will executing the SQL generated by mysql_tzinfo_to_sql cause any problems for the other schemas in MySQL?
 Q4. Is it required to restart MySQL after executing the SQL generated by mysql_tzinfo_to_sql?
 Q5. If the SQL generated by mysql_tzinfo_to_sql is executed on a replication master, should it also be executed on the replication slave?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.