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
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