Hi Mark,
I do have rights!
I'm logged in as administrator and as root in MySQL and the problem still
happens
If I flush the tables, then everything is ok...and I can figure out why...
The problematic areas are:
rename tables
alter tables types, e.g., from varchar to text.
creating indices
drop tables
Thank you
Anibal
----- Original Message -----
From: "Markus Lervik" <[EMAIL PROTECTED]>
To: "Anibal Cascais Santos" <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 12:50 PM
Subject: Re: Error on rename
> On Wed, 2002-07-03 at 20:29, Anibal Cascais Santos wrote:
> > Hi,
> > Newbie here...please be kind!
> >
> > Sometimes when I try to execute some SQL statment MySQL throws an Error
> > 7...(see below)
> >
> > For example:
> > ALTER TABLE `categorias` RENAME `catAnimais`;
> >
> > And here's the error
> > Error: 7 - Error on rename of '.\orniex\categorias.MYI' to
> > '.\orniex\#sql2-ffc-4.MYI' (Errcode: 13)
> >
>
> [mle@komplex mle]$ perror 13
> Error code 13: Permission denied
> [mle@komplex mle]$
>
> You don't seem to have rights to modify the table (ie, operating
> system-wise, not MySQL privileges).
>
> HTH,
> Markus
>
> --
> Markus Lervik
> Linux-administrator
> Vaasa City Library - Regional Library
> +358-6-325 3589 / +358-40-832 6709
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
