It might be a permissions problem. Mysql is trying to create a temporary
file to do the ALTER but cannot.
Check for the write permissions/ownership on the data directory.
Regard,
Bhavin.
- Original Message -
From: "Nick Stuart" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wedn
Thats what I thought, but wasnt the case. The directory was open to full
control by everyone. I did fix the problem though. It turns out this is
an issue with windows not letting anyone edit a file that is in use. And
when a table is used mysql will cache and hence windows thinks it's in
use and wi
>ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to
>'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13)
>Any ideas on why I would get this??
Errorcode 13 is permission denied or file not found. Either
.\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have
permission to over
It means you're connecting to the server as an annonymous user.
If you have a username to connect to the server, run the following
query:
mysql> show grants for your_user_name@localhost;
and it will show you all the priveleges that you have for specific
databases and tables. That's the best wa
Steve Osborne writes:
> ERROR 2000: Access denied for user: '@localhost' to database 'dbname'
>
> Can anyone give me some insight as to why I cannot do this? Do I require
> root privileges to do this (right now I am logged in as a user, as this
> remote server is an ISP)?
What unix user you a
are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;?
Steve Osborne wrote:
>Can anyone tell me why I am receiving the following error? I am connecting
>to a remote server via ssh, and accessed the mysql prompt by typing: mysql
> The following is the screen contents after try
es on the table so it does not appear to be fatal. Hmm.
- Dan
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/26/01, 12:11:09 PM, "Thalis A. Kalfigopoulos" <[EMAIL PR
Reffer documentation about mysql version and table type where you can do
that.
- Original Message -
From: "Daniel Adams" <[EMAIL PROTECTED]>
To: "LIBASOV IOANNIS" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:54 PM
Su
n a myisamchk to check on your indeces and
then try again.
regards,
thalis
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 3/26/01, 11:35:19 AM, "LIBASOV IOA
gt;>> Original Message <<<<<<<<<<<<<<<<<<
On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" <[EMAIL PROTECTED]> wrote regarding
Re: alter table error:
> It's better like this:
> alter table message add index subje
It's better like this:
alter table message add index subject2 (subject);
- Original Message -
From: "Daniel Adams" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:19 PM
Subject: alter table error
Can anyone tell me what this means and how to fix it? I ran the
11 matches
Mail list logo