OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Vexing permissions issue with partitioned CREATE TABLE

ceol-i-e.com
Date: Fri Dec 05 2008 - 15:01:52 CST

I've never created a partitioned table, but...

$ perror 13
OS error code 13: Permission denied

So I suspect some kind of file-system permissions issue...

Are you sure that the path you are giving isn't "relative" to the mysql data dir?

In which case it's trying to use something more like:
/var/mysql/data/foo/

Or, perhaps, you need to do the mkdir of idx_foo for it???

Or, perhaps, MySQL really doesn't like the idea of root-owned DB files, and wants them owned by MySQL user?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql