Jump to content
Larry Ullman's Book Forums

Installing Timezones On Mysql 5.5.9 Included With Mamp On Mac Osx Lion


Recommended Posts

Hi,

 

I hope someone can help here, as I'm starting to pull my hair out.

 

I've been trying to install the timezones that are discussed in Chapter 6 to my MySQL installation that is part of MAMP.

 

If I run the following command while in the /Applications/MAMP/Library/bin folder:

 

mysql_tzinfo_to_sql /usr/share/lib/zoneinfo | mysql -p -u root mysql

 

Terminal gives me the following error messages:

 

-bash: mysql_tzinfo_to_sql: command not found
-bash: mysql: command not found

 

Forgive me if I'm being daft and this something simple, but I just can't figure out what the problem is.

 

The relevant version numbers are below:

MySQL 5.5.9

Mac OS X 10.7.3

 

Thanks in advance for any help that anyone can offer.

Link to comment
Share on other sites

I knew it would turn out to be something simple!

 

./mysql and ./mysql_tzinfo_to_sql worked perfectly. The path for the zoneinfo directory I'd been given was slightly wrong too, the command I needed was:

 

./mysql_tzinfo_to_sql /usr/share/zoneinfo | ./mysql -p -u root mysql

 

Thanks so much for your help.

  • Upvote 2
Link to comment
Share on other sites

 Share

×
×
  • Create New...