11 May 2019 Databases Unknown or incorrect time zone: 'Europe/Berlin' After installing a new application on one of my server, i got following error message: Unknown or incorrect time zone: 'Europe/Berlin' Changing the locale settings didn’t help ahmet@testserver1:~$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 219 Server version: 10.1.38-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SET time_zone = 'Europe/Berlin'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'Europe/Berlin' The problem could be solved this way: ahmet@testserver1:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p Enter password: Warning: Unable to load '/usr/share/zoneinfo//leap-seconds.list' as time zone. Skipping it. Email Facebook Twitter LinkedIn Tumblr Reddit Google+ Pinterest Pocket