Apache Friends Support Forum

I was trying to add time zones to mysql database so, I went to the mysql manual there I found the tzinfor downloadable but, when I check in mysql directory C:/xampp/mysql/bin I see a file called mysql_tzinfor_to_sql.exe ,how do I access it on the mysql command prompt or I don't have timezone install on mysql .

Hi Watny Ablellard (there is ALWAYS time for an introducing welcome line, especially if you are asking for support on a community board. It's a matter of politeness),

Watny Ablellard wrote:so, I went to the mysql manual there I found the tzinfor downloadable

So, you should have read that paragraph:

http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html wrote:If your system has its own zoneinfo database (the set of files describing time zones), you should use the mysql_tzinfo_to_sql program for filling the time zone tables. Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X.

In the current version of XAMPP the timezone tables are already included (take a look into your \xampp\mysql\data\mysql\ folder) so no need to build them yourself with tzinfo_to_sql.
If you want to update the timezone tables, you can download the POSIX type here and extract them to your \xampp\mysql\data\mysql\ folder.

best wishes,
Altrea

Thanks for your help and sorry for not introducing myself.I'm looking forward to interacting with this community.