Did search alot and still could not fix by myself
I done below step still not work
under php.ini
[Date]
date.timezone="Asia/Hong_Kong"
under mysql -> bin -> my.ini
[mysql]
[Date]
;Defines the default timezone used by the date functions
Date.timezone = Asia/Hong_Kong
Saw few post about "mysql_tzinfo_to_sql — Load the Time Zone Tables"
But I have no idea how to start? (is that a .sql table import to?)
Have some expert can sharp the full step how to config ?
[Solved] - MySQL TimeZone Database Error
Moderators: Developers, Moderators
[Solved] - MySQL TimeZone Database Error
- Attachments
-
- Untitled.png (12.13 KiB) Viewed 18475 times
Last edited by areast on Sun Mar 11, 2018 9:23 pm, edited 1 time in total.
Re: MySQL TimeZone Support ERROR: Your MySQL TimeZone datab
.
Last edited by netniV on Sat Mar 10, 2018 2:11 am, edited 1 time in total.
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Re: MySQL TimeZone Support ERROR: Your MySQL TimeZone datab
The time zone table in mysql is a different thing than setting a timezone in php.ini.areast wrote: Saw few post about "mysql_tzinfo_to_sql — Load the Time Zone Tables"
But I have no idea how to start? (is that a .sql table import to?)
Have some expert can sharp the full step how to config ?
That table has to be filled with the all of the timezone information that is installed on the system. There is a program that reads this data and produces a *.sql file with INSERT INTO statements to populate that table.
The program is mysql_tzinfo_to_sql and is contained in the mysql-server package (or mariadb-server, if you use mariadb instead of mysql).
Call "man mysql_tzinfo_to_sql" to get command line parameter help. It is probably called as "mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql" to populate the table in one step, but depending on your system the directory may vary or the mysql user.
Re: MySQL TimeZone Support ERROR: Your MySQL TimeZone datab
Hi Tertius
Thanks for explain
I did solve "MySql timezone" with below step
http://www.geeksengine.com/article/popu ... mysql.html
Download the "timezone_2018c_posix" and paste under MySql -> Data
Thanks for explain
I did solve "MySql timezone" with below step
http://www.geeksengine.com/article/popu ... mysql.html
Download the "timezone_2018c_posix" and paste under MySql -> Data
Who is online
Users browsing this forum: No registered users and 0 guests