MySQL Server Time Zone Support mysql_tzinfo_to_sql  reads your system’s time zone files and generates SQL statements from them. mysql  processes those statements to load the time zone tables. mysql_tzinfo_to_sql  also can be used to load a single time zone file or generate leap second information: With this approach, you must execute a separate command to load the time zone file for each named zone that the server needs to know about. After running  mysql_tzinfo_to_sql , restart the server so that it does not continue to use any previously cached time zone data. If your system has no zoneinfo database (for example, Windows), you can use a package containing SQL statements that is available for download at the MySQL Developer Zone: Do  not  use a downloadable time zone package if your system has a zoneinfo database. Use the  mysql_tzinfo_to_sql  utility instead. Otherwise, you may cause a difference in datetime handling between MySQL and other applications on your system. To use an SQL-statement time zone package that you have downloaded, unpack it, then load the unpacked file contents into the time zone tables: Do  not  use a downloadable time zone package that contains  MyISAM  tables. That is intended for older MySQL versions. MySQL now uses  InnoDB  for the time zone tables. Trying to replace them with  MyISAM  tables causes problems. When time zone rules change, applications that use the old rules become out of date. To stay current, it is necessary to make sure that your system uses current time zone information is used. For MySQL, there are multiple factors to consider in staying current: •The operating system time affects the value that the MySQL server uses for times if its time zone is set to  SYSTEM . Make sure that your operating system is using the latest time zone information. For most operating systems, the latest update or service pack prepares your system for the time changes. Check the website for your operating system vendor for an update that addresses the time changes. Staying Current with Time Zone Changes Warning Warning •To load a single time zone file  tz_file  that corresponds to a time zone name  tz_name , invoke mysql_tzinfo_to_sql  like this: •If your time zone must account for leap seconds, initialize leap second information like this, where tz_file  is the name of your time zone file: mysql_tzinfo_to_sql  tz_file tz_name  | mysql -u root -p mysql mysql_tzinfo_to_sql --leap  tz_file  | mysql -u root -p mysql https://dev.mysql.com/downloads/timezones.html mysql -u root -p mysql <  file_name Then restart the server. 1002