How do you use MySQL InnoDB tables on OS X?

Question

I am having problems using InnoDB MySQL 5.0 on OS X due to a problem with my.cnf parameters. The gotchas enumeration in case it helps someone:

If InnoDB is disabled, check the error log (hostname.err, in the data directory). I had an empty setting which I changed:

 innodb_data_file_path = ibdata1:10M:autoextend

Hope this helps someone. I was running rails app and getting errors in session table.

-1

Kalid May 20 '09 at 8:21

1 answer

Morgan tocker · Answer 1 · 2010-07-24T14:23:38+0000

This is not actually required. InnoDB will automatically create two transaction log files and ibdata1 in / usr / local / mysql / data on Mac OS X.