Sample Header Ad - 728x90

MySQL timezone tables: mysql_tzinfo_to_sql docs are incorrect

0 votes
1 answer
104 views
A basic installation of MySQL creates, but does not populate, the several timezone-related tables in database "mysql". To populate those tables, you might consult: https://dev.mysql.com/doc/mysql-g11n-excerpt/8.0/en/time-zone-support.html (or similar for version 5.7). ... where the following command is shown
/usr/share/zoneinfo | mysql -u root -p mysql
However, this command fails. Solution in the answers below.
Asked by gwideman (101 rep)
Apr 8, 2024, 12:12 AM
Last activity: Apr 8, 2024, 08:05 PM