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;
 mysql alter table attr engine=NDB;
 ERROR 1005: Can't create table './database1/#sql-4627_3a.frm' (errno: 4009)

Seems weird. Can you check permissions in datadir/database1 and/or create a testcase 
for us? 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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: Can't create table './database1/#sql-4627_3a.frm' (errno: 4009)

-- 
._.
|   \0/John Stile |
| UniX Administration |
|   / \  510-305-3800 | 
| [EMAIL PROTECTED] |
.-.



signature.asc
Description: This is a digitally signed message part

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