sublimemonkey
-
Posts
2 -
Joined
-
Last visited
Posts posted by sublimemonkey
-
-
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.
Installing Timezones On Mysql 5.5.9 Included With Mamp On Mac Osx Lion
in PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition)
Posted
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:
Thanks so much for your help.