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 data
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
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
; <[EMAIL PROTECTED]>
Sent: Wednesday, 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
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
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: 13)
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
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
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
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.
Welco
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 mea
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
19 matches
Mail list logo
