sublimemonkey

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.

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.