sublimemonkey Posted March 5, 2012 Share Posted March 5, 2012 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 More sharing options...
rob Posted March 6, 2012 Share Posted March 6, 2012 Try it with ./mysql in the bin directory. You probably did, but make sure mamp is running. Link to comment Share on other sites More sharing options...
sublimemonkey Posted March 6, 2012 Author Share Posted March 6, 2012 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. 2 Link to comment Share on other sites More sharing options...
Recommended Posts