List:General Discussion« Previous MessageNext Message »
From:ceo Date:December 5 2008 9:01pm
Subject:Re: Vexing permissions issue with partitioned CREATE TABLE
View as plain text  
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?

Thread
Vexing permissions issue with partitioned CREATE TABLEBrad Heintz5 Dec
  • Re: Vexing permissions issue with partitioned CREATE TABLEFlorin Andrei6 Dec
Re: Vexing permissions issue with partitioned CREATE TABLEceo5 Dec
  • Re: Vexing permissions issue with partitioned CREATE TABLEBrad Heintz5 Dec
  • Re: Vexing permissions issue with partitioned CREATE TABLEPer Jessen6 Dec
    • Re: Vexing permissions issue with partitioned CREATE TABLEBrad Heintz7 Dec
    • Re: Vexing permissions issue with partitioned CREATE TABLEBrad Heintz8 Dec
Re: Vexing permissions issue with partitioned CREATE TABLEBrad Heintz5 Dec
  • Re: Vexing permissions issue with partitioned CREATE TABLEJohn Daisley6 Dec
    • Re: Vexing permissions issue with partitioned CREATE TABLEBrad Heintz6 Dec
      • RE: Vexing permissions issue with partitioned CREATE TABLEMartin Gainty6 Dec
        • Re: Vexing permissions issue with partitioned CREATE TABLEBrad Heintz6 Dec
      • Re: Vexing permissions issue with partitioned CREATE TABLEBrad Heintz7 Dec