Uploaded image for project: 'MariaDB Foundation Development'
  1. MariaDB Foundation Development
  2. MDBF-389

provide timezone data files

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Downloads
    • Labels:
      None

      Description

      Our kb on timezones for Windows does not provide a solution for 10.6+ because the MySQL timezones are incompatible (Offset is a keyword in MariaDB only).

      Because we now have a mirror service can we generate the timezones sql files here for distribution.

      Suggestion:

      A cron job that runs:

      $ docker pull docker.io/library/mariadb:10.6
      $ docker run --rm docker.io/library/mariadb:10.6 mariadb-tzinfo-to-sql /usr/share/zoneinfo > zoneinfo.sql
      

      The mariadb image is semi frequently updated as its ubuntu base image is also updated, hence bringing with it updated /usr/share/zoneinfo. Also as we do releases and the mariadb-tzinfo-to-sql changes we get that change automatically.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              faust Faustin Lammler
              Reporter:
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.75d
                  0.75d