Time Zone issues

[asink3]

I'm getting the typical time zone error but when I used the (mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -p mysql) fix, the server responds "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" I'm using Xampp could that have something to do with it?

[shaunw]

You need to find out how you can connect to MySQL from the console, then use that command for importing timezones. For instance you may need to use a command like:

mysql -h localhost

Unfortunately this is often different on every system.

[MichelleM]

asink3:

That error you quoted often means the MySQL server isn't running. Check http://dev.mysql.com/doc/refman/5.0/en/ ... erver.html for further details.

In other cases, your MySQL server could be configured to look for its temp (socket) file in the wrong place (distro MySQL vs. downloaded) and you'll get this error. Please see http://www.tech-recipes.com/mysql_tips762.html for an explanation. This issue is detailed on the MySQL forums here: http://forums.mysql.com/read.php?11,27769,147093.

Best of luck!

Michelle

Open Source works better when we all give back.