Re: Help with ALTER TABLE error

2004-10-22 Thread Egor Egorov
John Stile [EMAIL PROTECTED] wrote: I have Mysql Cluster (version 4.1.16-gama) running, and now I need to convert database tables from engine MyISAM to NDBCLUSTER, but ALTER TABLE fails on some tables. Does anyone know what the error means or how to get around it? mysql use database1;

Help with ALTER TABLE error

2004-10-19 Thread John Stile
I have Mysql Cluster (version 4.1.16-gama) running, and now I need to convert database tables from engine MyISAM to NDBCLUSTER, but ALTER TABLE fails on some tables. Does anyone know what the error means or how to get around it? mysql use database1; mysql alter table attr engine=NDB; ERROR 1005:

Re: Help with ALTER TABLE error

2004-10-19 Thread John Stile
On Tue, 2004-10-19 at 21:42, John Stile wrote: I have Mysql Cluster (version 4.1.16-gama) running, and now I need to Sorry, I meant version mysql-max-4.1.6-gamma-pc-linux-i686. signature.asc Description: This is a digitally signed message part

Alter table error

2003-01-08 Thread Nick Stuart
Got another problem with 4.0.7 when trying to alter the table. Trying to run: ALTER TABLE `call_information` CHANGE `close_date` `close_date` TIMESTAMP DEFAULT '' NOT NULL and it returns a: ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to '.\helpdesk\#sql2-b90-81.MYI' (Errcode:

RE: Alter table error

2003-01-08 Thread Jennifer Goodie
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

RE: Alter table error

2003-01-08 Thread Nick Stuart
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

Re: Alter table error

2003-01-08 Thread Bhavin Vyas
, January 08, 2003 2:15 PM Subject: Alter table error Got another problem with 4.0.7 when trying to alter the table. Trying to run: ALTER TABLE `call_information` CHANGE `close_date` `close_date` TIMESTAMP DEFAULT '' NOT NULL and it returns a: ERROR 7: Error on rename of '.\helpdesk

Sql Alter Table error handling

2002-06-12 Thread leonardo klarmann porto
HI, I would like to know how can i resume errors in a Alter Table sentence. I am doing a script that uses alter table to drop some columns of some tables in my converted access to mysql database. The problem is that if a column doesn´t exists in a certain table, the script

Re: Sql Alter Table error handling

2002-06-12 Thread Dan Nelson
In the last episode (Jun 12), leonardo klarmann porto said: HI, I would like to know how can i resume errors in a Alter Table sentence. I am doing a script that uses alter table to drop some columns of some tables in my converted access to mysql database. The problem is

ALTER TABLE error

2001-12-06 Thread Steve Osborne
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 trying to use the ALTER TABLE command; 'dbname' has been sub'd for actual database name. screen

Re: ALTER TABLE error

2001-12-06 Thread Mikel King
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

Re: ALTER TABLE error

2001-12-06 Thread Carl Troein
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 are

Re: ALTER TABLE error

2001-12-06 Thread sherzodR
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

alter table error

2001-03-26 Thread Daniel Adams
Can anyone tell me what this means and how to fix it? I ran the below query to simple add another index and this is what i got. Thank you. mysql alter table message add index subject2 (subject(10)); ERROR 1034: 126 for record at pos 176850808 - Dan

Re: alter table error

2001-03-26 Thread Daniel Adams
ANNIS" [EMAIL PROTECTED] wrote regarding Re: alter table error: 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: alte

Re: alter table error

2001-03-26 Thread Thalis A. Kalfigopoulos
and then try again. regards, thalis 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 subject2 (subject); - Original Message - From: &qu