mysql on macos x

[macubergeek]

I'm having trouble adding records to a database in mysql on macos x.
Just some background:
I loaded the database from a mysqldump file taken off a windows box.
database is named lookup with tables: ports, icmp and icmpcode.
I have two users jamesk and root

here are the grants:
+------------------------------------------------------------------------------------------------------------------------+
| Grants for jamesk@localhost |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'jamesk'@'localhost' IDENTIFIED BY PASSWORD '*E74858DB86EBA20BC33D0AECAE8A8108C56B17FA' |
| GRANT ALL PRIVILEGES ON `lookup`.* TO 'jamesk'@'localhost' |
| GRANT ALL PRIVILEGES ON `lookup`.`lookup` TO 'jamesk'@'localhost' |
+------------------------------------------------------------------------------------------------------------------------+

+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*E74858DB86EBA20BC33D0AECAE8A8108C56B17FA' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+

when I do:
use lookup;
INSERT INTO ports (Protocol,Port,Description) VALUES('udp',45678,'EBA PRISE');

I get:
mysql> INSERT INTO ports (Protocol,Port,Description) VALUES('udp',45678,'EBA PRISE');
Query OK, 1 row affected, 1 warning (0.04 sec)

but when I do a select on the record:
mysql> select * from ports where port = 45678;
Empty set (0.06 sec)

mysql>

Checking file jamesk.local.err
I see:
050521 18:58:06 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive

Now I'm wondering...The HFS+ filesystem I'm using is case insensitive could that be the problem here?

 

[macubergeek]

PS
I ran a test where I created a new database and found that as root I can create a database and inert into it just fine. Again this is creating the database on the mac not importing into it via mysqlimport.