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;
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:
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
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:
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
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
, 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
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
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
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
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
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
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
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
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
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
16 matches
Mail list logo