MySQL/MariaDB Timezone Tables

Foreword

This article explains how you can create MySQL Timezone Tables if they do not exist and you receive a corresponding message from your shopware application or similar. If you have a creoline server with the "Managed" support level, our customer support team will be happy to help you. These instructions can also be used for servers with an installed Plesk Control Panel.

Requirements

Installed MySQL server or MariaDB server
root access

MySQL server

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

Depending on which authentication method is used for the root user, the -p parameter can be omitted for authentication via password.

If you want to check whether the transfer process was successful, you can use the following command:

mysql -u root -p -e "SELECT * FROM mysql.time_zone_name;"

For Plesk servers, you can also use the following command:

mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "SELECT * FROM mysql.time_zone_name;"

Finally, the MySQL server must be restarted for the changes to take effect:

systemctl restart mysql.service

MariaDB server

 mariadb-tzinfo-to-sql /usr/share/zoneinfo | mariadb -u root mysql

Depending on which authentication method is used for the root user, the -p parameter can be omitted for authentication via password.

If you want to check whether the transfer process was successful, you can use the following command:

mysql -u root -p -e "SELECT * FROM mysql.time_zone_name;"

For Plesk servers, you can also use the following command:

mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "SELECT * FROM mysql.time_zone_name;"

Finally, the MySQL server must be restarted for the changes to take effect:

systemctl restart mariadb.service