Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am running MySQL 5.1 from package on Mac OSX 10.6. I am trying running: sudo /usr/local/mysql/bin/mysqld --skip-grant --user root --datadir=/usr/local/mysql/data

This error is preventing me from starting the database and importing the timezone information or doing anything else. I've tried clean installing with no luck.

Any suggestions?

share|improve this question

migrated from stackoverflow.com Nov 10 '11 at 8:05

This question came from our site for professional and enthusiast programmers.

You're probably looking for Etc/UTC. Correct the relevant setting in your MySQL config.

share|improve this answer

Named timezones are usable when they exist in your mysql database. In your case it seems that you don't have them there, so you can use offset relatives to UTC e.g: '+07:00' or '-04:00' or '+00:00'.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.