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
Last activity: Apr 8, 2024, 08:05 PM