Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-08 Thread Brad Heintz
list & the community were a big help in pointing me in the right direction. Cheers, - Brad On Sat, Dec 6, 2008 at 6:48 AM, Per Jessen <[EMAIL PROTECTED]> wrote: > Brad Heintz wrote: > > > Thanks for responding. > > > > The CREATE TABLE docs for 5.1 say that DATA DIR

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-07 Thread Brad Heintz
40 AM, Brad Heintz <[EMAIL PROTECTED]> wrote: > John - > > I've seen people confuse MySQL users with OS users, too. I'm not doing > that, and I understand the difference between MySQL privs and filesystem > permissions. MySQL is running as the mysql user. I'm r

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-07 Thread Brad Heintz
Per - I am finding a lot of exit=-13 entries for the mysql user, but that's the same information as in the original error message. Is there anything else you're suggesting I look for? - Brad On Sat, Dec 6, 2008 at 6:48 AM, Per Jessen <[EMAIL PROTECTED]> wrote: >

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-06 Thread Brad Heintz
> > This kind of problem crops up time and time again on the mysql forums > and > > > its always filesystem permissions or people confuse mysql users with os > > > users or think because they log into mysql as 'root' they have root > > > privileges on the b

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-06 Thread Brad Heintz
of problem crops up time and time again on the mysql forums and > its always filesystem permissions or people confuse mysql users with os > users or think because they log into mysql as 'root' they have root > privileges on the box. > > Regards, > > John > > What &g

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread Brad Heintz
e owner/group for the directories to root:root, mysql:mysql, > and > > myself, just to try it. No change. > > - The docs (if I have read everything correctly) indicate that specifying > > DATA DIRECTORY and INDEX DIRECTORY per partition in the manner above is > > le

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread Brad Heintz
iles, 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] > > -- Brad Heintz [EMAIL PROTECTED]

Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread Brad Heintz
e I could think of before posting to the list, but am no closer to an answer. Does anyone have any ideas? Have I missed something in the docs? Many thanks, - Brad Heintz -- Brad Heintz [EMAIL PROTECTED]