Is tzinfo_to_sql included in xampp 1.7.7

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Is tzinfo_to_sql included in xampp 1.7.7

Postby Watny Ablellard » 13. June 2012 20:47

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 .
Watny Ablellard
 
Posts: 2
Joined: 13. June 2012 17:48
Operating System: Window 7

Re: Is tzinfo_to_sql included in xampp 1.7.7

Postby Altrea » 13. June 2012 22:11

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Is tzinfo_to_sql included in xampp 1.7.7

Postby Watny Ablellard » 14. June 2012 00:33

Thanks for your help and sorry for not introducing myself.I'm looking forward to interacting with this community.
Watny Ablellard
 
Posts: 2
Joined: 13. June 2012 17:48
Operating System: Window 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 47 guests