Resolved mysql_tzinfo_to_sql

[Maris]

Hello guys,

could anyone give a hand how to populate mysql timezones?
so far I tried this (since mysql's admin password in plesk is always unknown and i should get it from psa.shadow)

but the output is:

[root@servah ~]# mysql_tzinfo_to_sql /usr/share/zonefile | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin
There were fatal errors during processing of zoneinfo directory '/usr/share/zonefile'
ERROR 1046 (3D000) at line 4: No database selected

Using latest MariaDB, CentOS7

Thanks

 

[AYamshanov]

[root@servah ~]# mysql_tzinfo_to_sql /usr/share/zonefile /usr/share/zoneinfo | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin

 

[Maris]

[root@servah ~]# mysql_tzinfo_to_sql /usr/share/zonefile /usr/share/zoneinfo | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin

[root@servah ~]# mysql_tzinfo_to_sql /usr/share/zoneinfo | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin
ERROR 1046 (3D000) at line 4: No database selected

Same problem

 

[AYamshanov]

[root@servah ~]# mysql_tzinfo_to_sql /usr/share/zoneinfo | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql

 

[Maris]

Fantastic, this one worked, wondering why they do not put these simple things in their tutorial pages so beginners could easily make thing shappen. Thank you so much!