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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]